About
Pricing
Community
Teams
Start Free Trial
Log in
espanolanthony
asked on
10/1/2012
Table partitioning in SQL
I have a SQL table that has almost 800K rows in it. Because of the performance I need to do table partition. Can someone suggest some tips on how to partition existing table. I am pretty new to partitioning and no knowledge about partitioning.
Microsoft SQL Server
Microsoft SQL Server 2008
3
1
Last Comment
espanolanthony
8/22/2022 - Mon
Vijaya Reddy Pinnapa Reddy
10/1/2012
Check these articles,
http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/
http://sqlandme.com/2011/08/09/sql-server-how-to-partition-an-existing-table/
ASKER CERTIFIED SOLUTION
espanolanthony
10/2/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
espanolanthony
10/7/2012
ASKER
thanks
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/
http://sqlandme.com/2011/08/09/sql-server-how-to-partition-an-existing-table/