September 30, 2008 at 7:52 pm
Hi,
I am uisng SQL Server 2000. Can I partition a huge table in SQL Server 2000 or it only feature in 2005? Does partitioning increase query performance.
Thanks
Lee
September 30, 2008 at 10:10 pm
Table partitions were added in SQL 2005.
October 1, 2008 at 6:14 am
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
October 1, 2008 at 6:21 am
Can you please explain the procedure for partitioning a table ?
Thank You.
Regards,
Raghavender Chavva
October 1, 2008 at 6:27 am
1. Search BOL.
2. Kimberly's article is the best. http://msdn.microsoft.com/en-us/library/ms345146.aspx
October 1, 2008 at 6:29 am
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
October 3, 2008 at 5:47 pm
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.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply