Contribute to Ebony7/SQL-SERVER-DOMAIN development by creating an account on GitHub.

Truncate Table Partitions.md File metadata and controls Preview Code Blame 33 lines (25 loc) · 554 Bytes Raw 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 To ...

A TRUNCATE statement is preferred since it just drops all data pages associated with the table, does not fire table triggers, and resets IDENTITY columns. In the case above, I resorted to using DELETE ...