In this post, I am sharing a new version of TRUNCATE command which used to truncate the partitions and newly introduced in SQL Server 2016. Always we keen like why we cannot apply WHERE condition or any other filter in TRUNCATE Command. TRUNCATE command is faster than delete because it consumes the fewer resources than … Continue reading SQL Server 2016: Introduce New TRUNCATE by Partitions Number