November 2006 - Posts

• Did you know? -- Deadlock Graph Event Isn't Generated When Filtering on DatabaseID

  As many of you know, I am a big fan of SQL Server Profiler and all the wonderful things you can do with tracing. I was very excited about some of the enhancements to the SQL Server 2005 tracing functionality. However, over the last couple of days, I discovered Read More... Posted Tuesday, November 28, 2006 9:48 PM by Kalen Delaney | 17 Comments

• Did you know? -- SQL Server 2005 Best Practices site is available

  I am writing this post at an altitude of 35000 ft (10668 m) on a flight to Sydney, Australia. I am on my way to Melbourne, to present my SQL Server Architecture, Internals and Tuning class for our Solid Quality Learning Australian subsidiary ( www.SolidQualityLearning.com.au Read More... Posted Saturday, November 25, 2006 4:22 PM by Kalen Delaney | 0 Comments

• Geek City: Variable Length Storage for Exact Numerics

  I finally have recovered from the PASS conference last week, and connected to the blog site to see nothing but PASS posts on the front page! I guess I better get cracking if I want to maintain my visibility. J One of the sessions at PASS was called “Hidden Read More... Posted Monday, November 20, 2006 9:20 AM by Kalen Delaney | 1 Comments

• Did you know? -- Better than sp_configure

  I’ve mentioned before that the new metadata is so voluminous that I’ve barely skimmed the surface. Last week in class in Minneapolis ( www.nhmn.com ) one of my students discovered an alternative to sp_configure. You’re probably aware that by default, Read More... Posted Monday, November 06, 2006 2:06 PM by Kalen Delaney | 2 Comments Filed under: configuration, metadata