SQL Server Performance Forum – Threads Archive
Partition TableHi 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,
Search for partitioned views in BOL. I guess you are not aware that partitioning on mssql server is far from straight-forward.