Table Partitioning Question RRS feed

  • Question

  • Hi,

    We are planning to partition one Fact table with size greater than 500 GB. I want to understand that is there any performance improvement if I store different partitions on different filegroups.

    Can I get performance improvement if I am using PRIMARY filegroup to store all my partitions.

    I am going to partition table with the strategy as - Partition Function - Partition Scheme - Create Partition table - Migrate data.




    Wednesday, January 12, 2011 6:35 AM


  • Start from here
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    This posting is provided "AS IS" with no warranties, and confers no rights.
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    • Proposed as answer by sandglass Friday, January 14, 2011 11:55 AM
    • Marked as answer by WeiLin Qiao Monday, January 24, 2011 10:12 AM
    Wednesday, January 12, 2011 7:00 AM

All replies