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 » SQL Server 2005 » TRUNCATE   (RSS)
  • 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