SQL Saturday #71 Wrap-up

PASS
It’s over. It’s finally over. This year, unlike previous years, Adam Machanic (blog|twitter) was very good about delegating the work. Which, is actually a mixed blessing. I did a lot more work this year than I have done in years past. Luckily, we had more help this year from, new MVP, Mike Walsh (blog|twitter) and Tom LaRock (blog|twitter). The team came together and pulled off the event with the help of a great set of volunteers. Of special note, Allen White’s (blog|twitter) wonderful wife, Cindi, stood at the front desk all day, and in other ways helped us organize and run the event. It would not have been the same without her. Thanks so much. We couldn’t have pulled it off without our vendors. Here is the rather substantial list.…
Read More

SQL University–Recommendations for a Clustered Index

SQL Server, T-SQL
Welcome, SQL University Students to another extension class here at Miskatonic University, home to the Fighting Cephalopods (GO PODS!). Never mind the stains on the floor, or the walls…or those really nasty ones on the ceiling. There was a… oh what did the dean call it… an incident last week when one of the students had a little accident after reading Die Vermiss Mysteriis one too many times. But we’re not here to talk about arcane tomes and unspeakable horrors today. No, today we’re here to talk about clustered indexes. SQL Server storage is really predicated around the idea of clustered indexes. Don’t believe me? Let’s list a few places that require a clustered index: Partitioning. A table in SQL Azure In order to create XML indexes What about the…
Read More