在SQL Server 2000 数据仓库中使用分区

CREATE TABLE [dbo].[sales_fact_19990101] (
　 [date_key] [int] NOT NULL
CHECK ([date_key] BETWEEN 19990101 AND 19991231),
　 [product_key] [int] NOT NULL ,
　 [customer_key] [int] NOT NULL ,
　 [promotion_key] [int] NOT NULL ,
　 [store_key] [int] NOT NULL ,
　 [store_sales] [money] NULL ,
　 [store_cost] [money] NULL ,
　 [unit_sales] [float] NULL
)
ALTER TABLE [sales_fact_19990101]
ADD PRIMARY KEY (
[date_key], [product_key], [customer_key], [promotion_key], [store_key])

CREATE TABLE [dbo].[sales_fact_20000101] (
　 [date_key] [int] NOT NULL
CHECK ([date_key] BETWEEN 20000101 AND 20001231),
　 [product_key] [int] NOT NULL ,
　 [customer_key] [int] NOT NULL ,
　 [promotion_key] [int] NOT NULL ,
　 [store_key] [int] NOT NULL ,
　 [store_sales] [money] NULL ,
　 [store_cost] [money] NULL ,
　 [unit_sales] [float] NULL
)
ALTER TABLE [sales_fact_20000101]
ADD PRIMARY KEY (
[date_key], [product_key], [customer_key], [promotion_key], [store_key])

CREATE VIEW [dbo].[sales_fact]
AS
SELECT * FROM [dbo].[sales_fact_19990101]
UNION ALL
SELECT * FROM [dbo].[sales_fact_20000101]

INSERT INTO [sales_fact]
VALUES (19990125, 347, 8901, 0, 13, 5.3100, 1.8585, 3.0)
INSERT INTO [sales_fact]
VALUES (19990324, 576, 7203, 0, 13, 2.1000, 0.9450, 3.0)
INSERT INTO [sales_fact]
VALUES (19990604, 139, 7203, 0, 13, 5.3700, 2.2017, 3.0)
INSERT INTO [sales_fact]
VALUES (20000914, 396, 8814, 0, 13, 6.4800, 2.0736, 2.0)
INSERT INTO [sales_fact]
VALUES (20001113, 260, 8269, 0, 13, 5.5200, 2.4840, 3.0)

SELECT TOP 2 * FROM sales_fact WHERE date_key = 19990324