THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Browse by Tags

All Tags » Inside SQL Server   (RSS)
  • Geek City: Reading the Transaction Log

    Sorry, I'm not actually going to tell you how to read the log. I'm just going to talk about it... and whether it's a good thing to be able to do or not, or whether it's an absolutely crucial feature that MS needs to provide for us immediately, in a hotfix, if not sooner. Forget about fixing bugs, I want to read the log because I forgot to set up a ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 23, 2008
  • Geek City: How SQL Server Detects the Correct Versioned Rows

    Here is a question I just received from the feedback page on my web site: I have finished the book <the storage engine> and like it very much. I am now reading <query tuning and optimization> I know in the READ COMMITTED SNAPSHOT isolation, when a row is being modified in a transaction, it generates an old committed version so ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 3, 2008
  • Did You Know? My DVD is in Production!

      The editing for Lesson 1 is done and the production run of my DVD has started. We're expecting shipping to start in about 2 weeks. In addition, we've extended the pre-order price for another 5 days, so any orders that come in before Valentine's Day will get the special reduced price. Because this is taking a bit longer than we hoped, we ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 8, 2008
  • Did You Know? I'm Going Down Under Again!

    Most of my trips to the Southern Hemisphere have been in my summer, or their winter, which doesn't lend itself to the best weather conditions. Although on my last trip, I was able to take a week holiday with my husband and travel North to the Whitsunday Islands, where the weather was wonderful even in the middle of winter, as you can ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 29, 2007
  • Did You Know? SP2 does NOT limit the amount of plan cache you can have

      As I am preparing my talk for the UK SQL Server Users Group on November 16, I was going through other presentations on plan cache management. At the PASS Conference in Denver in September there was a session on management of cache, and I was surprised to find a slide that indicated there was a hard upper limit for plan cache size, and ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 4, 2007
  • Inside SQL Server... the next book

      The last volume of Inside SQL Server 2005 (Query Tuning and Optimization) is now in the hands of MS Press. This is the first time I have worked on a Inside book as a group project, and for some strange reason I thought that meant that I could get the book done more quickly. We were desperately trying to get it done in time to be available ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 14, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement