Partitioning

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29389 More actions · Answer 1

One Orange Chip

Points: 29389

September 30, 2008 at 10:10 pm

Table partitions were added in SQL 2005.

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 2

And yes, for large tables, they can increase performance.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 3

Can you please explain the procedure for partitioning a table ?

Thank You.

Regards,
Raghavender Chavva

Glen SSCertifiable Points: 6737 More actions · Answer 4

1. Search BOL.

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 5

Straight out of the Books Online:

CREATE PARTITION FUNCTION myRangePF1 (int)

AS RANGE LEFT FOR VALUES (1, 100, 1000) ;

GO

CREATE PARTITION SCHEME myRangePS1

AS PARTITION myRangePF1

TO (test1fg, test2fg, test3fg, test4fg) ;

GO

CREATE TABLE PartitionTable (col1 int, col2 char(10))

ON myRangePS1 (col1) ;

GO

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Nikhil Shikarkhane Default port Points: 1498 More actions · Answer 6

Tip :-

Once you implement partitioned table and are going to implement Sliding window.

Make sure that you split and merge partitions which are empty.

Splitting or merging a partition(s) containing millions of rows in it will be

catastrophic for your IO.