Partition Table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Partition Table

Hi ALL, I got a large Data warehouse table with 10 million records, when i am querying that table performance is very slow.So i am planning to partition that table i.e data in different tablespaces.
I need syntax for Partioning table. Thanks,
Ram.
Search for partitioned views in BOL. I guess you are not aware that partitioning on mssql server is far from straight-forward.
]]>