Table Partitioning in SQL Server 2005

Question

Post reply

Table Partitioning in SQL Server 2005

abmore

Hall of Fame

Points: 3628
More actions
July 23, 2008 at 12:29 am

#188477

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Dugi SSCoach Points: 17998 More actions · Answer 1

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/[/url]

J.Yogesh Old Hand Points: 317 More actions · Answer 2

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

tim.pinder Old Hand Points: 322 More actions · Answer 3

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

Table Partitioning in SQL Server 2005

Cookies on SQLServerCentral