VS 2005 & SQL 2005 auf MSDN downloadbar

By Frank Kalis

Posted on Okt 28, 2005 von in SQL Server
MS scheint seinen Zeitplan einzuhalten. :)
Dieser Eintrag wurde eingetragen von und ist abgelegt unter SQL Server.

1 Kommentar

Kommentar von: Todd Harvey

Todd Harvey
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
16.06.06 @ 20:49


Formular wird geladen...