November 27, 2008 at 3:59 am
Hi All,
I have to partition some tables (not databases) in ms sql 2005. Is it possible to do so without having to drop the database.
Thanks for your advise.
A.
November 27, 2008 at 5:01 am
I don't think anyone would go in for partitioning if it entailed dropping the database :)...in other words - it is very much possible to partition your tables without dropping your database.
Check this article out - http://msdn.microsoft.com/en-us/library/ms345146.aspx for a very good overview of partitioning
November 28, 2008 at 9:55 pm
Are you looking to partition the tables across multiple file groups or databases? What is the problem you are trying to solve?
November 30, 2008 at 12:39 am
Yes you are right.
I am trying to move to different filegroups based on the partition key.
Thanks
A.
November 30, 2008 at 12:49 am
amit (11/30/2008)
Yes you are right.I am trying to move to different filegroups based on the partition key.
Thanks
A.
This has nothing to do with dropping the database. If you have only one file group or you don’t have enough file groups you can simply add new file groups and files to the database. Check out alter database in BOL
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2008 at 9:04 pm
To put it simple, i have a table of 2million rows and i want to partition that. The database already have 2 filegroups to use. Can you please help me out with this. Is there any alter statement which can be used here??
Cheers
A.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply