Database locking is a fundamental concept in SQL Server that every Database Administrator and Database Developer should understand. SQL Server has a pessimistic locking model because it was built for an OLTP environment and assumes that updates will occur frequently. For a developer, this is important to understand in terms of concurrency: how many users…
Statistics and Recompilations, Part II
I recently blogged about an interesting behavior in SQL Server when the database option, Auto Update Statistics, is disabled…and that post requires a sequel. The summary is that when you have the Auto Update Statistics option disabled for a database, query plans for tables are not recompiled when their statistics are updated. There is an…
Vendor Feedback
I don’t know how many of you receive the SQLskills Insider email (sign up here), but if you know me, you know I’m a fan of SQLskills so of course I’m on the distribution list. Anyway, in Monday’s email Paul Randal talked about application vendors and how he frequently hears about incorrect configuration recommendations made…
January’s Performance VC LiveMeeting: In the books!
Yesterday was the first LiveMeeting hosted by the Performance Virtual Chapter in 2012 and it went very well, in spite of a few glitches! I am so proud of our team; it was a solid team effort. Carlos ( b | t ) had asked Jason Strate ( b | t ) to be our…
