Browse by Tags

• concurrency
• isolation
• locking
• PASS
• scripts
• seminars
• SQL Server 2008

• Geek City: 24Hours of PASS Followup

  Thank you everyone who attended my 24HOP session yesterday. It was a wonderful event to be part of. Here are a few of the questions that I was asked, that didn't get completely answered. Question: Can we set READ_COMMITTED_SNAPSHOT ON for just a table Read More... Posted Thursday, September 16, 2010 12:20 PM by Kalen Delaney | 0 Comments Filed under: concurrency, isolation, locking, PASS, seminars, sparse columns Attachment(s): 24HoursofPASS Sept 2010 Delaney.zip

• Geek City: Too Many Columns!

  As I am working on my new SQL Server 2008 internals book, I am finding many test situations in which I need to create a table with LOTS of columns. First of all, you're probably aware of the new SPARSE column feature that allows you to have up to 30,000 Read More... Posted Saturday, September 20, 2008 7:52 PM by Kalen Delaney | 9 Comments Filed under: scripts, sparse columns, SQL Server 2008