Tag Archives: Indexing

Red Gate – SQL Server Index Manager – Beta 2

Posted on April 25, 2012 by

Red Gate released the first Beta for their new Index Manager back in December, and I blogged about it then.  They have recently updated the Beta, and so I downloaded it and had another play. First attempt to use it, … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

Red Gate – SQL Index Manager – Beta

Posted on December 16, 2011 by

Once again, those lovely chaps at Red Gate have come up with a new tool for the DBA – SQL Index Manager, and Grant “Scary” Fritchey (blog|twitter) has even done a video about it on YouTube. So, let’s download it … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 6 Comments

Index Maintenance for SQL2k

Posted on July 29, 2011 by

Once again, the “smart indexing in SQL2000″ question has raised its ugly head on AskSSC.  Those of you in SQL2005 and above have the opportunity to use some fine index maintenance scripts from Ola Hallengren and Michelle Ufford (among others, … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment

Inappropriate Indexes, and Programming Your Way Around Them

Posted on September 1, 2010 by

(This article should probably be called “Inappropriate Primary Keys…”, but that wouldn’t have the assonance…) Seeing various questions on AskSSC about using GUIDs as indexes, including GUIDs which are actually stored in Varchar(255) fields, reminded me of this little vignette … Continue reading →

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , , , | Leave a comment