I have a situation. When a user updates a fact table it locks the table and thus selects take a long time.
I am thinking of using either READ_COMMITTED_SNAPSHOT or Dirty Reads.
Can someone tell me why one would be better then the other and visa versa ie pros and cons of each?
View Complete Post