SQLServerCentral / Discuss Content Posted by Unknown Unknown / Article Discussions / Article Discussions by Author / Truncate v Delete / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 04:56:42 GMT20RE: Truncate v Deletehttp://www.sqlservercentral.com/Forums/Topic425509-34-1.aspxEASY ONE.....GOOD STA:-)RT OF THE DAYThu, 29 Nov 2012 23:34:36 GMTkapil_kkRE: Truncate v Deletehttp://www.sqlservercentral.com/Forums/Topic425509-34-1.aspxAs TRUNCATE TABLE removes the data by deallocating the data pages used to store the table's data, it is practically impossible (at least until now) to segment this command, given the fact that a page can be share by several rows, or a row could be distributed among several pages. So the TRUNCATE TABLE command can't be deterministic, so speak.Thu, 29 Nov 2007 15:21:57 GMTWellington AquinoRE: Truncate v Deletehttp://www.sqlservercentral.com/Forums/Topic425509-34-1.aspxFor more info regarding Truncate and Delete read the following article.http://www.sqlservercentral.com/articles/delete/61387/Sun, 25 Nov 2007 13:19:34 GMTPrashant PandeyTruncate v Deletehttp://www.sqlservercentral.com/Forums/Topic425509-34-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/T-SQL/61544/">Truncate v Delete</A>[/B]Sun, 25 Nov 2007 13:17:40 GMTSite Owners