Last post Dec 31, 2005 10:44 AM by cathal
Nov 28, 2005 10:34 AM|JiltedCitizen|LINK
Nov 29, 2005 05:23 PM|cathal|LINK
Dec 30, 2005 01:10 PM|portvista|LINK
Dec 30, 2005 05:40 PM|IcthusTech|LINK
Dec 30, 2005 06:35 PM|cjsmitty|LINK
Dec 30, 2005 07:17 PM|IcthusTech|LINK
LOL, Can't you make it harder than that!
Dec 30, 2005 07:53 PM|portvista|LINK
Dec 31, 2005 04:18 AM|cjsmitty|LINK
Dec 31, 2005 10:16 AM|portvista|LINK
Dec 31, 2005 10:44 AM|cathal|LINK
FYI: From SQL books online
"TRUNCATE TABLE is functionally identical to DELETE statement with no WHERE clause: both remove all rows in the table. But TRUNCATE TABLE is faster and uses fewer system and transaction log resources than DELETE.
The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table's data, and only the page deallocations are recorded
in the transaction log.
TRUNCATE TABLE removes all rows from a table, but the table structure and its columns, constraints, indexes and so on remain. The counter used by an identity for new rows is reset to the seed for the column. If you want to retain the identity counter, use
DELETE instead. If you want to remove table definition and its data, use the DROP TABLE statement"