- "... a scholar and a true gentleman." - Buck Woody, Microsoft's "Real World" SQL Server DBA.
- Agresso AskSSC Assyst Axios Azure Backup Book Review Books Career Certification Cluster Configuration CSV CTE DBCC Denali Deployment Design Disaster Recovery Documentation Education Error Message ETL Execution Plans Full Text Indexes Indexing Installation IT Management Kaseya Kindle Maintenance Maintenance Plans Management Meme Monday Memory Migration Misconceptions Monitoring MSDB Myths Normalization People Performance PowerShell Programming red-gate Restore SQL Agent SQLBits SQL Monitor SQLPrompt SQLSaturday SQL Server SQL Server 2000 SQL Server 2005 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQLSouthWest SSMS ssmstoolspack SSRS T-SQL T-SQL Tuesday Tools Training Troubleshooting Un-SQL Friday Upgrade User Group Virtual Machines Windows 2012 WordPress WTF XML
Tag Archives: Indexing
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 →
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 →
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 →
(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 →