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 ServerMicrosoft SQL Server 2008

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.

Certified Expert Program

Credly Partnership

Udemy Partnership