SQL-Articles

Tag: partitioning

  • How to do Table Partitioning to an existing source table

    In this article we are going to see how to partition a existing table in a database. In my working place I got a request from client to partition an existing table, I have searched in BOL but couldnt find the exact detail how to do it. Ive figured out that and Implemented successfully, Im…

  • Creating Partitioned Tables

    The following are the steps to create a partitioned table. 1.) Create a partition function 2.) Create a partition scheme 3.) Create a table using the partition scheme.

  • Partitioning

    Partitioning is all about dividing of datas to make it faster access either by reading or writing into the table. i.e improving query execution time. Partitioning can be done at Table and Index level. These are the new features in SQL server 2005 and these are supported only at Enterprise and Developer edition. The data…

  • Systables related to partitioning

    Below listed are the systables which can be used to get information regarding partitioned tables, indexes are views.

  • Pros and Cons of Partitioning

    This article describe pros and cons of partitioning in SQL Server