Categories
DBA

SQL Server 2016 – Truncate Table Supports Partitioning

It’s been a month after the new year started. Hope everyone is having a wonderful time.

This is my first post for this year and it’s a simple one but most of them are looking around for this option quite from SQL Server 2012.

Categories
General

Difference between TRUNCATE and DELETE command

 

Lets see the difference between DELETE and TRUNCATE command as below