SQL Server Performance

Truncating a Partitioned Table

Discussion in 'ALL SQL SERVER QUESTIONS' started by Hrishi_nk, Jun 24, 2012.

  1. Hrishi_nk New Member

    Recently I created a partitioned table having day wise partition.I populated the table with some dummy data for 2-3 days.As I was testing I truncated the table.After having a look at sys.partitions I found that the partition number is starting from 4 and all before partition numbers 1,2 and 3 are missing .My question is does truncating a partitioned table merge the boundaries of all the partition having data.
  2. Shehap MVP, MCTS, MCITP SQL Server

    Truncate table shouldn't remove partitioning boundaries as it just remove data entity exists there without removing partitioning boundaries which can be controlled only using Merge /Split commands used within switch in/out processes ex:

Share This Page