Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kartik.kaveeshwar
Starting Member
18 Posts |
 Posted - 2008-06-16 : 01:54:15
|
| i want to partition a table containing about 3 million rows. The partition column will be of datetime type.following is the partition function i have usedcreate partition function MyPartFun (datetime) as range left for values ('07/30/2007','09/30/2007','11/30/2007','01/30/2008','04/30/2008')following is the partition scheme i have usedcreate partition scheme PartScheme aspartition MyPartFun all to ([primary])i know how to add partition column while creating the tableBut dont know how to add above partition scheme to an already populated tablePlz help... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-16 : 02:07:35
|
| http://blog.benhall.me.uk/2008/04/creating-partition-tables-in-sql-server.html |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-16 : 14:27:01
|
| 3 million rows is not big so that you have to partition. What is the estimated growth of table? |
|
|
|
|
|
|
Table Partitioning