THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Internals » Transactions   (RSS)
  • TSQL Tuesday #11:Rolling Back TRUNCATE TABLE

    “It ain't what people don't know that hurts them it's what they know that ain't so”  -- commonly attributed to Mark Twain SQL Server has been around for a long time now, and people who learn one version well sometimes have  monumental task when a new version comes out. They need to figure out what changed. The ''What's New'' ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 12, 2010
  • 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
Privacy Statement