O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Designing data partitioning solutions for tables and indexes

As part of performance improvement techniques, partitioning the table or index may improve the query performance depending upon the query types and hardware configuration. SQL Server 2005 introduced the data partitioning solutions and from the beginning of SQL Server 2008, this feature has been enhanced with native table and index partitioning, which provides better scalability to the data platform.

As the data grows, tables grow larger and similarly, the data access time also tends to increase. By designing the data partitioning solutions with appropriate hardware, we will be able to build a scalable and high performance platform. In this recipe, we will look at designing data partitioning ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required