Here's one for the SQL Server gurus: if I set my SQL Server 2008 transaction isolation level to READ UNCOMMITTED
, does that also affect the index pages?
E.g. using ISOLATION LEVEL READ UNCOMMITTED
, what effect (if any) do the ALLOW_PAGE_LOCKS
or ALLOW_ROW_LOCKS
on an index have??
ALTER INDEX IX_FirstName ON Employee
SET (ALLOW_PAGE_LOCKS=OFF, ALLOW_ROW_LOCKS=OFF)
I can't seem to find a definitive answer anywhere - the MSDN documentation on the transaction isolation levels really only talks about the data pages....