SQL Server 2005 Partition Tables

[sendba]

Hi all

I have a table which contains more than 500 Million records in SQL Server 2000 database.I want to take advantage of 2005 Partitioned Tables.

Can anyone let me know how to partition the table so that i have 100 Million in each partitions.

Please help

Thanks in advance

 

[mrdenny]

Look up "partitioned tables [SQL Server], creating" in BOL.

When you parition the table you partion it by a date range, or a key range not by a number of records.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com