Post reply

Fact Table Partitioning

  • October 12, 2009 at 5:39 am

    #136496

    Hi Folks,

    Can any one let me know the best way to partition the fact table in SQL Server?

    Currently we have Fact table created on one disk drive which is DataDisk2 and Indexes for the fact table created on IndexDrive2. We wanted to implement the partition for this table and I have decided to partition it while recreating the clustered index key.

    My question here is can I create the fileGroups and datafiles in IndexDrive2 Disk for clustered index. If I create them in IndexDrive2, how the table data in DataDisk2 is handled?

    also we are planning to archive the data so will the above partition method will help archiving?

  • October 12, 2009 at 6:16 am

    #1064679

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic801495-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply