https://www.insidesql.org/blogs/frankkalis/?disp=comments de-DE http://backend.userland.com/rss 60 Fri, 16 Jun 2006 18:49:20 +0000 Todd Harvey c223@https://www.insidesql.org/blogs/ Frank, You commented as follows at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=170880 Is it really a physical delete or isn't the record marked as ghost record? -- Frank Kalis Microsoft SQL Server MVP www.insidesql.de Heute schon gebloggt? www.insidesql.de/blogs Your comment was in response to the statement: Delete is a physical delete - each row gets deleted and logged. Truncate is a logical delete that deallocates the extents used by the table, marking them as empty for reuse, although the physical data pages still contain the data rows. The deallocation of the extents is logged. Do you have further information as to which statement is actually true? Todd https://www.insidesql.org/blogs/frankkalis/2005/10/28/vs_2005_aamp_sql_2005_auf_msdn_downloadb#c223