"Transparent" Benefits of SQL Server 2005

Did you know? In SQL Server 2005: DBCC – uses snapshot framework avoiding locks – no table level schema locks sys.dm_db_index_physical_stats replaces DBCC SHOWCONTIG – Both of these tools doesn’t require S lock.  It only require IS lock Rebuilding clustered index does not necessarily rebuild associated nonclustered indexes unless the keyword ALL is specified Asynch stats update…

0