Database Reference
In-Depth Information
create unique clustered index IDX_Orders2014_OrderDate_OrderId
on dbo.Orders2014(OrderDate, OrderId)
with (data_compression = page)
on psOrders2014(OrderDate);
create nonclustered index IDX_Orders2014_CustomerId
on dbo.Orders2014(CustomerId)
with (data_compression = page)
on psOrders2014(OrderDate);
create table dbo.Orders2014_05
(
OrderId int not null,
OrderDate datetime2(0) not null,
OrderNum varchar(32) not null,
OrderTotal money not null,
CustomerId int not null,
/* Other Columns */
constraint CHK_Orders2014_05
check(OrderDate >= '2014-05-01' and OrderDate < '2014-06-01')
);
create unique clustered index IDX_Orders2014_05_OrderDate_OrderId
on dbo.Orders2014_05(OrderDate, OrderId)
with (data_compression = row)
on [FASTSTORAGE];
create nonclustered index IDX_Orders2014_05_CustomerId
on dbo.Orders2014_05(CustomerId)
with (data_compression = row)
on [FASTSTORAGE]
/* dbo.Orders2014_06 table definition */
create view dbo.Orders(OrderId, OrderDate, OrderNum
,OrderTotal, CustomerId /*Other Columns*/)
with schemabinding
as
select OrderId, OrderDate, OrderNum
,OrderTotal, CustomerId /*Other Columns*/
from dbo.Orders2012
union all
select OrderId, OrderDate, OrderNum
,OrderTotal, CustomerId /*Other Columns*/
from dbo.Orders2013
union all
