Greetings, Professor Falken It’s time for some education, peeps, and I am not talking about SQLUniversity, which started two weeks ago. These are the final days before the first SQLSaturday event in Cleveland. I have been part of the planning committee and let me tell you, my hat is off to anyone who has ever planned…
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…
On the Fifth Day of SQL…
Welcome to the Twelve Days of SQL series hosted by Brent Ozar ( blog | @BrentO ), I have the honor of hosting the fifth day! I won’t be passing out golden rings, but I did want to share one of my favorite posts from the year. Parallelism, Processing and Options In May, Adam Machanic…
