May 2009 - Posts

• Did You Know? I'll be teaching a public course in Boston!

  I receive a lot of requests for classes on the East Coast, and I am very pleased to announce my first new public training partner in the US in more than 5 years! Since I am drastically cutting back on my travel, this will probably be my last new public Read More... Posted Tuesday, May 19, 2009 12:25 PM by Kalen Delaney | 20 Comments Filed under: internals, training

• Did You Know? I'll be at TechEd!

  I'm delivering a session on Tuesday morning (May 12) called "Controlling Your Query Plans", and for most of the rest of Tuesday, Wednesday and Thursday I'll be at the ATE (Ask the Experts) Area. Feel free to stop by! ~Kalen Read More... Posted Friday, May 8, 2009 11:23 AM by Kalen Delaney | 10 Comments Filed under: conference, plan guides, query plans, TechEd

• Geek City: Controlling Lock Granularity

  In all versions of SQL Server since 7.0, the engine could choose to lock rows, pages or the entire table. In addition, even if it starts out your query execution by obtaining row or page locks, if too many locks are acquired, SQL Server could escalate Read More... Posted Sunday, May 3, 2009 6:51 AM by Kalen Delaney | 32 Comments Filed under: escalation, indexes, locking