Partitioning in SQL Server — Decoding Data


SQL Server supports table and index partitioning, which basically divides the data horizontally into multiple filegroups in a database. The benefits of partitioning a large table are: Improved query performance. Partitioned table on multiple filegroups when placed on different disks, can improve I/O performance. Partition level manageability. Instead of maintaining complete table, indexes can be […]

via Partitioning in SQL Server — Decoding Data

Advertisements