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.
    Hrishi_nk, Jun 24, 2012
    #1

  2. Shehap Moderator

    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:
    Shehap, Jun 28, 2012
    #2

Share This Page