Posts

Showing posts from January 16, 2013

Database Expert's Table Partitioning on larger sized tables.

Image
Table Partitioning on Larger sized Tables OLTP Database There is need when database tables grown very large. Click here to know more, Table Partitioning Four thing to be done before partitioning. 1.Database with Multiple FileGroup. 2.Create partition Function. 3.Create Partition Scheme. 3.Create partition. Now,We follow above four steps to make table as partitioned. 1. Create FileGroup for Partition . USE [master] GO ALTER DATABASE [ DatabaseName ] ADD FILEGROUP [FG01] GO ALTER DATABASE [ DatabaseName ] ADD FILEGROUP [FG02] GO ALTER DATABASE [ DatabaseName ] ADD FILEGROUP [FG03] GO ALTER DATABASE [ DatabaseName ] ADD FILEGROUP [FG04] GO Add Files in Each file group.Assign Different file path. USE [master] GO ALTER DATABASE [ DatabaseName ] ADD FILE ( NAME = N'FG01', FILENAME = N'C:\FG01\FG01.ndf' , SIZE = 1048576KB , FILEGROWTH = 1024KB ) TO FILEGROUP [FG01] GO ALTER DATABASE [ DatabaseName ] ADD FILE ( NAME = N'FG02',