Sample Data for This Chapter
Throughout the chapter, I will use the Performance database and its tables in my examples. Run the code in Example 4-1 to create the database and its tables and populate them with sample data. Note that it will take a few minutes for the code to finish.
Example 4-1. Creation script for sample database and tables
SET NOCOUNT ON; USE master; IF DB_ID('Performance') IS NULL CREATE DATABASE Performance; GO USE Performance; GO -- Creating and Populating the Nums Auxiliary Table SET NOCOUNT ON; IF OBJECT_ID('dbo.Nums', 'U') IS NOT NULL DROP TABLE dbo.Nums; CREATE TABLE dbo.Nums(n INT NOT NULL PRIMARY KEY); DECLARE @max AS INT, @rc AS INT; SET @max = 1000000; SET @rc = 1; INSERT INTO dbo.Nums(n) VALUES(1); WHILE @rc * 2 <= ...