Home     Documentation


Step-by-step guides

Console Utility Usage Scenarios

  • Sample 1

    In this example, we use the dbo.Orders table partitioned by the OrderDate column. At the end of each month, a partition with new data is added to a table, and data from the earliest month is deleted.

  • Sample 2

    This scenario differs from the previous one in certain features: check-constraints are added to the table for limiting the data set to the desired range. But, these constraints need to be changed because the range is changed over time.

  • Sample 3

    In this example, we use the dbo.Orders and dbo.OrderDetails tables, dbo.OrderDetails has foreign key that refers to dbo.Orders. Now, you must perform all partitioning operations on both tables. Do not forget that the data must be consistent.

  • Sample 4

    In this scenario, data from the earliest months is transferred to the dbo.Orders_Archive and dbo.OrderDetails_Archive archive tables, instead of being deleted from the dbo.Orders and dbo.OrderDetails tables.