January 6, 2009 at 10:15 pm
Hi,
I have a large table of 30 gb. Now i want to fragment the table to a number of smaller tables(say 6 tables each of 5 gb). It doesn't matter which rows go into all tables. My only concern is that no rows should be inserted into more than 1 table ie no duplicacy. And each row should be in exactly one of the smaller tables.
How can I achieve this?
Thankx
January 7, 2009 at 2:19 am
Look for Partitioning Tables in Books Online....
--Ramesh
January 7, 2009 at 4:28 am
Yes! partitioning is the best solution if you are using SQL 2005/08. If not, then I need the definition of your table to provide you with an alternative.
-Vikas Bindra
-Vikas Bindra
January 7, 2009 at 4:28 am
Partitioning only works with developer edition and enterprise edition.
See here http://weblogs.sqlteam.com/peterl/archive/2008/06/12/Horizontal-partitioning-Enterprise-style.aspx how you can manage that.
If you are not using Enterprise edition, not developer edition, see this blog post how to mimic same thing
http://weblogs.sqlteam.com/peterl/archive/2007/09/24/Horizontal-partitioning.aspx
N 56°04'39.16"
E 12°55'05.25"
January 7, 2009 at 6:10 am
You are going to have to be able to identify the partitioning mechanism, the column or columns that identify where the data is stored. While your post says it doesn't matter, in fact, that's the first thing you need to do.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply