June 2, 2010 at 6:04 am
Can any one help me in this regrad.
I tried a lot in google but not succeed
How can we bifurcate a big table and please let me know what are the steps we have to follow before\after bifurcation
June 4, 2010 at 6:14 am
You mean partitioning?
-- Gianluca Sartori
June 7, 2010 at 2:48 am
No it is not a prtitioning, we have to move the table to a different file group with all indexes and every thing.
June 7, 2010 at 3:14 pm
OK, basically it's the same thing. I don't remember the exact syntax and I don't have SSMS here, but you will have to rebuild the clustered index into a new filegroup.
It's something like CREATE CLUSTERED INDEX index_name ON table_name (column_list) WITH DROP_EXISTING ON filegroup_name.
I'm sorry, this is all I can remember right now.
Good luck!
-- Gianluca Sartori
June 7, 2010 at 3:19 pm
if for some reason this table does not have a clustered index then simply create into your new filegroup, either way if it is a large table this could take some time
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply