Search code examples
c#sql-serversql-server-2008storagedatabase-partitioning

Partitioning tables in SQL Server, will it affect my software?

  1. Do I need to update my software to support partitioned table?
  2. Does partitioning tables in SQL Server change my database table?
Solution

  • Refering to Partitioned Tables and Indexes in SQL Server 2005:

    SQL Server 2005 offers a way to easily and consistently manage large tables and indexes through partitioning, which allows you to manage subsets of your data outside of the active table. This provides simplified management, increased performance, and abstracted application logic, as the partitioning scheme is entirely transparent to the application.

    Read the provided article to learn the best practices about tables partitioning in sql server.

    Also refer to:

    Partitioned Table and Index Concepts

    Designing Partitions to Improve Query Performance