InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 08:00:07 GMT20http://www.sqlservercentral.com/Forums/Topic954650-145-1.aspx[quote][b]ningaraju.n (7/19/2010)[/b][hr]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.[/quote]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?Mon, 19 Jul 2010 06:20:23 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic954650-145-1.aspx...Another nice resource about partition: [url=http://bit.ly/aBD7EY]http://bit.ly/aBD7EY[/url]Mon, 19 Jul 2010 03:10:34 GMTDugihttp://www.sqlservercentral.com/Forums/Topic954650-145-1.aspxMany things to do and to prepare for the partitioning:The first location and with all details about partitions is here: http://tinyurl.com/3xvo6zgAfter that take a look the script here: http://tinyurl.com/2wlodhlAnd please make a search about partition in the SQLServerCentral you will find many resources!http://tinyurl.com/36hw6ke[i]Let us now something during the implementation![/i]Have a great day!Dugi :cool:Mon, 19 Jul 2010 03:05:57 GMTDugihttp://www.sqlservercentral.com/Forums/Topic954650-145-1.aspxHi 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.Mon, 19 Jul 2010 02:47:05 GMTningaraju.n