November 2009 - Posts

• Did You Know: You can Learn SQL Internals in Sweden!

  The class next week was full, but we just had two cancellations today. So now you have a chance to take my SQL Server Internals and Tuning class next week, at the wonderful Cornerstone Training Center , right outside of Stockholm. (I promise I'll have Read More... Posted Monday, November 30, 2009 5:33 PM by Kalen Delaney | 0 Comments Filed under: internals, training

• Geek City: Intent to Update

  In the last couple of months, I've told you about Intent Locks and UPDATE locks. I want to just provide a wrap up to those posts that talks about both of these aspects of locking. You can think of both of these locking aspects as although SQL Server to Read More... Posted Thursday, November 19, 2009 5:33 PM by Kalen Delaney | 1 Comments Filed under: locking

• Geek City: UPDATE Locks

  UPDATE locks are not really a separate kind of lock, but rather are a hybrid of SHARED and EXCLUSIVE locks. And contrary to what you might think, UPDATE locks are not just acquired for UPDATE operations. A transaction acquires this kind of lock when SQL Read More... Posted Friday, November 13, 2009 2:48 PM by Kalen Delaney | 6 Comments Filed under: locking

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

  The Boston class was so successful, both for me and for all the attendees, that I have been persuaded to do another public class on the East Coast. This one is being arranged by Scott Klein, of the South Florida SQL Server Users' Group, and will be held Read More... Posted Thursday, November 12, 2009 3:21 PM by Kalen Delaney | 0 Comments Filed under: internals, training

• Geek City: Fragmentation and Forwarded Records in a Heap

  I know it's been a while since I had a technical post, and I've got 3 of them started and saved as drafts. I keep waiting for spare time. Now that PASS is over, and I've crawled partway out from under the TO-DO pile that accumulated while I was preparing Read More... Posted Wednesday, November 11, 2009 6:31 PM by Kalen Delaney | 10 Comments Filed under: forwarding pointers, fragmentation, internals