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 » truncate   (RSS)
  • Geek City: Did You Know … that not everything you know is actually true!

    Software changes, new versions not only add new features, they also change internal behavior of old features,  and not all the changes are documented!  And how often, after a software upgrade, do you go through and test everything you knew was true, to make sure it is STILL true after the upgrade? I write books about the SQL Server ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 27, 2013
  • Connect Digest : 2011-12-20

    Make SSMS start faster A couple of years ago, I blogged about some ways to make Management Studio start faster. With the latest builds of SQL Server 2012, it seems to be slower than ever, at least when starting SSMS for the first time after a reboot or install. So I've asked for them to do something in the background on Windows start-up ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 20, 2011
  • When are pages from a truncated table reused?

    Mr CheckDb Paul Randal has an interesting post about the fact that if a table is truncated inside a transaction, what protects the integrity of the table's pages in case the transaction rolls back?  It is really interesting because you can see what is going on behind the scenes Check it out here: Search Engine Q&A #10: When are pages ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on December 6, 2007
  • SQL Myth: Truncate Cannot Be Rolled Back Because It Is Not Logged

    I am still amazed at how many people still think that TRUNCATE TABLE is not logged. There is some logging going on but it is minimal, here is what Books On Line says:   TRUNCATE TABLE removes the data by deallocating the data pages used to store the table's data, and only the page deallocations are recorded in the transaction ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on June 13, 2007
Privacy Statement