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...