Table bifurcation in sqlserver

  • 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

  • You mean partitioning?

    -- Gianluca Sartori

  • No it is not a prtitioning, we have to move the table to a different file group with all indexes and every thing.

  • 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

  • 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