SQL Server should provide a statement that allows truncating a partition in a partitioned table. Currently, it is possible to truncate an entire table using TRUNCATE TABLE. There should be a command to do just that for a single partition.Currently, one needs to create a a table with partition-aligned schema, switch out the partition and drop the table. This is tedious and error prone. TRUNCATE PARTITION should provide just that.