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.
]]>