December 2004 Entries
Clustered Index Details As promised here are some more details on clustered indexing. For those of you who always wondered what that little checkbox was when you were creating an index in SQL Enterprise Manager, I hope to clear up a bit of the confusion. I need to work on adding some diagrams to this, but hopefully this will be helpful. I will try my best to do this without trying to rehash the SQL Books Online… So first, I guess it would be prudent to start at the beginning. When you create...
It has been silent, here for the last couple of weeks. I am expecting my fourth child any day now. As to the silence…stupidly, I accepted an offer to paint my neighbor’s basement. I now know why I didn’t choose painting as a career path. The guy wouldn’t even look at the work until I had two coats on. At least I had a power sprayer. I am just putting the finishing touches on my indexing post—hope it is not too long or too repetitive to what is already out there. Brian...