I am optimizing a querry, for this simple table:
(a few other columns not participating in the query)
I am experiencing a weird problem... I do an update on a record in a table and sometimes i can read this record from a different connection...
Thank you for your answer Frank!
but i have a follow up question.
I know insert takes an exclusive lock but I am not sure exactly how it plays out....
I have been looking for an aswer without much luck so i certainly hope one of you can help! :)
Want to insert a row to a...
well i know 4gb is not neccessary but I want the entier index to fit in memory no? the database size is (exepected to be) around 4gb. most of this...
Thank you for your thoughts!
Some questions - when you say "separate partition for your FT data" - do you mean seperate physical disks? or...
I am developing a asp.net application using sql server 2005 with full-text searching.
I am looking for a recommnded...
Separate names with a comma.