July 2010 - Posts

• Geek City: My Big Fat Partitioning Query

  When SQL Server first introduced table and index partitioning in SQL 2005, it was the same version that all the metadata changed. So I decided that I could learn a lot about metadata and a lot about the organization and storage of partitions if I tried Read More... Posted Monday, July 26, 2010 9:45 AM by Kalen Delaney | 4 Comments Filed under: metadata, partition functions

• Did You Know? MVP Deep Dives is Deal of the Day at Manning!

  If, for who knows what reason, you haven't yet got your copy of the SQL MVP Deep Dives book , you can't pass it up today. It is the "Deal of the Day" at Manning , and you can get it for only $25! Check it out at at: http://www.manning.com/nielsen/ (the Read More... Posted Monday, July 26, 2010 8:45 AM by Kalen Delaney | 3 Comments Filed under: books, MVP

• Did You Know: My Online Seminar Lasted Almost 5 Hours!

  Yesterday was a rebroadcast of the index internals seminar I presented last February, and I had forgotten how long it was. I was in a chat room the whole time, and the questions just kept coming, fast and (not so) furious! Thanks to all the participants Read More... Posted Saturday, July 24, 2010 6:06 PM by Kalen Delaney | 0 Comments Filed under: indexes, internals, seminars, training

• Geek City: Index Internals

  Once again, I'll be presenting an online seminar through SSWUG . This on is on Index Internals . The presentation lasts over 3 and a half hours, and I'll be online for live chat for over 4 hours. Ask away! We'll look at juicy details of exactly how clustered Read More... Posted Monday, July 19, 2010 8:15 AM by Kalen Delaney | 0 Comments Filed under: indexes, seminars, training

• TSQL Tuesday #8: Those who can, do, and those who want to learn more, teach!

  It's time for the eighth T-SQL Tuesday , managed this time by Robert Davis at SQL Server Central . This time, the topic was announced very late, and I was just starting to write a blog post of my own when I saw it. Fortunately, my topic easily fits into Read More... Posted Tuesday, July 13, 2010 8:02 AM by Kalen Delaney | 6 Comments Filed under: query plans, showplan, T-SQL Tuesday