Tag Info

New answers tagged

1

As you say truncate doesn't use the transaction log resources a DELETE would. TRUNCATE is not technically classed as a minimally logged operation but is very efficiently logged as it just deallocates the pages and extents relevant to the data. Nothing wrong with TRUNCATE, its logged you can rollback and its quick. Remember TRUNCATE wont fire triggers, if ...


3

There are certain circumstances where you cannot use the TRUNCATE TABLE command and must use the DELETE command instead. You cannot use TRUNCATE TABLE on tables that: • Are referenced by a FOREIGN KEY constraint. (You can truncate a table that has a foreign key that references itself.) • Participate in an indexed view. • Are published by ...



Top 50 recent answers are included