Vipul Shah's SQL Blogs

SQL Server Blogs

Browse by Tags

Related Posts
  • Blog Post: "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...