Tag Archives: Indexing

Red Gate – SQL Server Index Manager – Beta 2

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

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

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

(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