Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Truncate v Delete Expand / Collapse
Author
Message
Posted Sunday, November 25, 2007 1:17 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Truncate v Delete
Post #425509
Posted Sunday, November 25, 2007 1:19 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 17, 2008 9:27 PM
Points: 81, Visits: 128
For more info regarding Truncate and Delete read the following article.
http://www.sqlservercentral.com/articles/delete/61387/


Thanks,
Prashant
Post #425510
Posted Thursday, November 29, 2007 3:21 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 5:39 PM
Points: 69, Visits: 189
As 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.
Post #427819
Posted Thursday, November 29, 2012 11:34 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:27 AM
Points: 1,890, Visits: 2,329
EASY ONE.....
GOOD START OF THE DAY



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1391054
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse