DBCC IndexDefrag
Being day 16 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC INDEXDEFRAG. Description: DBCC INDEXDEFRAG was used for to defragment… Read More »DBCC IndexDefrag
Index Fragmentation
Making Progress on the Server Health Re-write
Originally I implemented the Database Health Reports as a series of SQL Server Reporting Services reports, which was very handy and easy to create, but hard… Read More »Making Progress on the Server Health Re-write
SQL Server Health Reports — Working on Version 2
Late last year and early this year, I created a collection of report in SSRS that I called SQL Server Health reports. Some of the… Read More »SQL Server Health Reports — Working on Version 2
Abstracts submitted to SQL Saturday
I just submitted abstracts to SQL Saturday #114 in Vancouver and #108 in Redmond. The Redmond SQL Saturday appears to be the more popular of… Read More »Abstracts submitted to SQL Saturday
Index Fragmentation and SHRINKDATABASE
Is it a good idea to run DBCC SHRINKDATABASE regularly? Download the sample file ShrinkSample. This article and samples apply to SQL Server 2005, 2008,… Read More »Index Fragmentation and SHRINKDATABASE