Table Partitioning in SQL Server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Abhijit » Table Partitioning in SQL Server 2005

Table Partitioning in SQL Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

abmore

Posted Wednesday, July 23, 2008 12:29 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:06 AM
Points: 1,134, Visits: 818

Comments posted to this topic are about the item Table Partitioning in SQL Server 2005

Post #539016

Dugi

Posted Wednesday, July 23, 2008 12:33 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

Nice one ... short explanation very good ...how about partition in many data files not just primary!
w00t

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #539018

J.Yogesh

Posted Thursday, January 05, 2012 7:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 27, 2012 2:50 AM
Points: 5, Visits: 32

This is really good example.

But i have a heavy loaded table on which i need to implement this.

So from your example instead of 'create table' can anyone suggest me how implement this using 'Alter Table' sort of script on existing table...

Thanks
Yogesh

Post #1230714

tim.pinder

Posted Thursday, November 29, 2012 6:17 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, February 04, 2013 9:24 AM
Points: 25, Visits: 177

This tells me all I need to know: I don't understand so partitioning is not for me. Unsure

Post #1390489

« Prev Topic | Next Topic »

Permissions