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?
ISOLATION LEVEL READ UNCOMMITTED, what effect (if any) do the
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....