Truncate v Delete

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Unknown Unknown » Truncate v Delete

Truncate v Delete

Rate Topic

Display Mode

Topic Options

Author

Message

Site Owners

Posted Sunday, November 25, 2007 1:17 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

Comments posted to this topic are about the item Truncate v Delete

Post #425509

Prashant Pandey

Posted Sunday, November 25, 2007 1:19 PM

SSC 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

Wellington Aquino

Posted Thursday, November 29, 2007 3:21 PM

Valued Member

Group: General Forum Members
Last Login: Friday, July 30, 2010 5:17 PM
Points: 69, Visits: 130

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

kapil_kk

Posted Thursday, November 29, 2012 11:34 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 7:11 AM
Points: 1,130, Visits: 1,278

EASY ONE.....
GOOD STA Smile

RT OF THE DAY

Post #1391054

« Prev Topic | Next Topic »

Permissions