Tag: Index Fragmentation

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 indexes on SQL Server 2000, the same thing can be done with Alter Index on

Tagged with: , , ,

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 to distribute in a way that they could be shared and customized to the needs

Tagged with: , , , , , , ,

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 things that the Server Health report evaluates are the following Index Fragmentation Big One Time Use Queries

Tagged with: , , , , , , ,

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 the two.  Who knows if my session will get accepted, but I am giving it

Tagged with: , , , , ,

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, and 2008R2. This really depends on a number of factors, but generally the answer is

Tagged with: , , , , , , ,
Top