SQL Server Rebuild Indexes – The Fastest Way

Want to rebuild all the indexes in your MS SQL database?  The script below will rebuild all the indexes in your SQL Server 2008 or SQL Server 2005 (SP2) database and offers a number of enhancements that make this the best SQL Server index rebuild script in all the land and the first choice of… Continue reading SQL Server Rebuild Indexes – The Fastest Way

SQL Server Read Committed Snapshot – Is it on?

How do you check whether read committed snapshot is on or off for a particular SQL Server database using SQL Server Management Studio?  We've never been able to find it but this quick T-SQL query will show you the answer.   (Also check out our post on checking whether Snapshot Isolation is on):

Published
Categorized as Scripts