In SQL Server, what is the difference between DELETE and TRUNCATE with respect to transaction logging?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

In SQL Server, what is the difference between DELETE and TRUNCATE with respect to transaction logging?

Key points

  • DELETE fully logs each row removal for full recovery
  • TRUNCATE is minimally logged for faster performance
  • TRUNCATE produces less granular log records
  • Transaction logging impacts data recovery and audit trails

Ready to go further?

Start full exam Practice more questions

Related questions