Monthly Archives: January 2011

sp_helpindex: Remember what you’re missing

Back in December I blogged about the usefulness of the DISABLE INDEX option which was added in SQL Server 2005. In that post I mentioned using sp_helpindex to verify which indexes existed for a table and what columns were in those indexes. If I had to rebuild an index in SQL Server 2000, this option…

TSQL Tuesday #014: Resolutions

It’s January. It’s the second Tuesday of the month. In the SQL world, that means it’s a TSQL Tuesday! This month’s edition is hosted by newly minted SQL Server MVP Jen McCown ( blog | @JenniferMcCown ) and the chosen topic is, “What technical resolutions have you been pondering, and why?” I typically do not…