108 reputation
3
bio website
location
age
visits member for 2 years, 3 months
seen Sep 6 '13 at 16:47

Aug
4
awarded  Scholar
Aug
4
accepted single select vs multiple selects using limit and offset
Aug
3
comment single select vs multiple selects using limit and offset
we are on SQL Azure. The isolation level Read Committed snapshot seems to be a database level setting. We have several transactions running as Serializable. Would this setting affect those transactions?
Aug
3
comment single select vs multiple selects using limit and offset
Nope. There are other transactions that happen on the customers table from which the 20k records are selected. I do not want this select to block these transactions as they are more important.
Jul
31
awarded  Supporter
Jul
31
awarded  Student
Jul
31
asked single select vs multiple selects using limit and offset