Partitioning

[sendba]

All

I have a table which is 700 Million record.
I would like to use Partition table feature in SQL Server 2005. Can someone let me know which is the easiest way to partition the table.

Can I apply the partition to an existing table, if yes how to do it.

thanks all for your help

Sen

 

[mrdenny]

You can't apply a partition to an existing table. You have to create a new partitioned table, then load your data into it.

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

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

http://www.mrdenny.com