Wednesday, June 6, 2018

Improve stored procedure performance in SQL Server (Partitioning)

SQL Server supports table and index partitioning. The data of partitioned tables and indexes is divided into units that can be spread across more than one filegroup in a database. The data is partitioned horizontally, so that groups of rows are mapped into individual partitions.

0 comments: