Database Reference
In-Depth Information
select OrderId, OrderDate, OrderNum
,OrderTotal, CustomerId /*Other Columns*/
from dbo.Orders2014
union all
select OrderId, OrderDate, OrderNum
,OrderTotal, CustomerId /*Other Columns*/
from dbo.Orders2014_05
union all
select OrderId, OrderDate, OrderNum
,OrderTotal, CustomerId /*Other Columns*/
from dbo.Orders2014_06;
It is worth mentioning that table
Orders2014
is partitioned on a monthly basis up to end of the year, even though
it stores the data up to the operational period, which starts in May.
CHECK
constraints in that table indicate this.
The data layout is shown in Figure
15-6
.
Figure 15-6.
Using partitioned tables and views together: Data layout