SQL Server 2016 - Truncate at Partition level
Enhancements to TRUNCATE in SQL Server 2016:
SQL Server 2016 introduced truncation at partition level without logging at the individual rows.
This is kind of having WHERE clause to DELETE statement.
The new TRUNCATE statement in SQL Server 2016 is:
SQL Server 2016 introduced truncation at partition level without logging at the individual rows.
This is kind of having WHERE clause to DELETE statement.
The new TRUNCATE statement in SQL Server 2016 is:
TRUNCATE
TABLE
dbo.PartitionedTable
WITH
(PARTITIONS (2, 4, 6
TO
8))
Above statement will truncate all the partitions 2, 4, 6, 7 and 8.
Labels: new features in SQL server 2016, new in SQL Server 2016, sql server 2016 new features, truncate in sql, truncating partitions in sql server
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home