Geek Answers Handbook

Splitting existing tables

How to create an existing table in SQL Server 2005/08? I could not find a better clue.

+5
source share
2 answers

Here is a complete article on how to do this. (Create table, insert data, then section)

Trick - move the table to a new section.

DROP INDEX MyTable_IXC ON MyTable WITH (Move To [Data Partition Scheme] (ID) )
+6
source

Since you are not making any mistakes, I suppose you are looking for general information on how to do this? Separation is not something that you can master in just a few seconds. Some information on this subject can be found in the following links.

SQL2005: http://msdn.microsoft.com/en-us/library/ms188706(SQL.90).aspx

SQL2008: http://msdn.microsoft.com/en-us/library/ms188706.aspx

sqlskills article http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

0

More articles:


All Articles