March 2018
Intermediate to advanced
816 pages
19h 35m
English
So far, only an unsuccessful insert was tested. Of course, you can also try to insert some valid data. Before that, let's drop the constraint since it is not needed for further explanation:
ALTER TABLE dbo.FactTest DROP CONSTRAINT U_SaleKey; GO
Next, you can insert some valid rows. The following statement inserts 113,990 rows into the test fact table. Note that this is more than the 102,400 row limit for trickle inserts; therefore, you should expect this to be treated as a bulk insert:
INSERT INTO dbo.FactTest (SaleKey, CustomerKey, Customer, CityKey, City, DateKey, StockItemKey, Product, Quantity, TotalAmount, Profit) SELECT 11 * 1000000 + f.[Sale Key] AS SaleKey, cu.[Customer Key] AS CustomerKey, ...