Category: DBA
-
Pros and Cons of Partitioning
This article describe pros and cons of partitioning in SQL Server
-
Data Partitioning
Introduction: This article takes introduces you to the concept of data partitioning in SQL server 2005. It also gives you an example of how to start from the scratch and also how to partition an already existing table.
-
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…
-
How Partitioned table works
Partitioning is nothing but dividing of datas according to the requirement to improve query performance. Consider you are having a table with large number of datas. Here in table partitioning we are going to implement horizontal partition, where the rows in the table will be based on one the column in table.