July 19, 2010 at 2:47 am
Hi Friends,
I have a table with more than 30 million records .now i thought of partitioning the table on primary key please suggest me the approach.
July 19, 2010 at 3:05 am
Many things to do and to prepare for the partitioning:
The first location and with all details about partitions is here: http://tinyurl.com/3xvo6zg
After that take a look the script here: http://tinyurl.com/2wlodhl
And please make a search about partition in the SQLServerCentral you will find many resources!
Let us now something during the implementation!
Have a great day!
Dugi 😎
July 19, 2010 at 3:10 am
...Another nice resource about partition: http://bit.ly/aBD7EY
July 19, 2010 at 6:20 am
ningaraju.n (7/19/2010)
I have a table with more than 30 million records .now i thought of partitioning the table on primary key please suggest me the approach.
I usually ask myself a series of questions when the idea of partitioning a table pops-up on my mind, here are the basic ones:
1- Any particular reason to partition this table?
2- How many partitions?
3- What would be the partitioning key?
4- Would partitioning strategy help during archiving and purging of this table?
5- Would partitioning strategy improve performance? How and why?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply