Posts Tagged ‘WingTipToys2012’

TSQL: Partitioned table exercise for 70-462

Here’s some TSQL for the WingTipToys2012 table partitioning exercise in the 70-462 training materials. ?View Code TSQLCREATE DATABASE WingTipToys2012   USE WingTipToys2012; GO   CREATE PARTITION FUNCTION WTPartFunction(INTEGER) AS RANGE LEFT FOR VALUES (30, 60)   CREATE PARTITION SCHEME WTPartScheme AS PARTITION WTPartFunction TO (fgOne, fgTwo, fgThree);   CREATE TABLE toys ( column1 INTEGER NOT […]