Table Partitioning

  • We need to implement table partitioning and develop an SSIS package to load that table.

    We also need to archive the old data as read only and keep only the active data.can somebody provide help regarding this.

  • I suggest you start from reading on the topic. There's plenty of resources out there, starting from BOL and technet.

    I found this[/url] article very helpful.

    This one is also very interesting.

    Hope this helps.

    Gianluca

    -- Gianluca Sartori

  • Please read online help of microsoft.

  • Are you planning to use partition to archive the data. If so what will be the key for partition.

Viewing 4 posts - 1 through 3 (of 3 total)

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