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.
Difference between TRUNCATE and DELETE command
Lets see the difference between DELETE and TRUNCATE command as below