Tag Archives: Indexing

What A Difference An Index Makes

Posted on June 18, 2017 by thomasrushton

M’colleagues over the way were having problems with an upgrade / feature installation of McAfee EPO UDLP (no, I have no idea what that means). Looking at what was happening on the SQL Server that’s at the back of that … Continue reading →

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

SQL Server Non-Unique Clustered Indexes Are Evil!

Posted on June 4, 2017 by thomasrushton

Non-Unique Clustered Indexes Are Evil And We Have The Proof. You won’t believe it when you see it. Face it – I can’t write click-bait… I was reading Grant Fritchey’s (Blog|@gfritchey) comments in the SQL Server Central forum thread “Advice … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 2 Comments

Red Gate – SQL Server Index Manager – Beta 2

Posted on April 25, 2012 by thomasrushton

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 thomasrushton

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 thomasrushton

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 thomasrushton

(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