SQL Server 2016 enhancements – SQL Truncate Table and Table Partitioning

The idea behind this article is to discuss the importance and the implication of SQL Partition and understand the SQL truncate command partitioning enhancements in SQL 2016 One of the biggest challenges for a DBA is to identify the right candidate for table partitioning, as it requires expertise in design and implementation. The following are … Continue reading SQL Server 2016 enhancements – SQL Truncate Table and Table Partitioning