In this example name the function TransactionHistoryFunction. This will create a function that maps the rows of the table or index into partitions based on the values of the TransactionDate column. The next screen, Select a Partition Function, create the partition function. If you do not select this option, you may place indexes independently of the columns they point to. Storage Align Non Unique Indexes and Unique Indexes with an Indexed Partition Column: Aligns all indexes of the table being partitioned with the same partition scheme. In this example, choose “TransactionDate” partitioning the table based on the date when the transaction was entered into this table.Ĭollocate this table to the selected partition table: Displays related data to join with the column being partitioned. ![]() ![]() The most common column used is a date column since most tables are being archived by date. On the Select a Partitioning Column screen as shown below select the column that you want to use to partition your table. To start the wizard, right click on the table you want to partition in SQL Server Management Studio and select Storage, Create Partition. ![]() Microsoft SQL Server 2008 introduced a table partitioning wizard in SQL Server Management Studio that helps make this task easier. The T-SQL code to create partition functions, partition schemes, and then altering the table to use the partition can be overwhelming for some database administrators.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |