Listing 1: Code to Create and Populate the Employees Table in the testdb Database
SET NOCOUNT ON;
USE master;
GO
-- Create database testdb
IF DB_ID('testdb') IS NOT NULL
  DROP DATABASE testdb;
GO
CREATE DATABASE testdb;
GO
USE testdb;
GO

-- Create table Employees
IF OBJECT_ID('dbo.Employees', 'U') IS NOT NULL
  DROP TABLE dbo.Employees;
GO
CREATE TABLE dbo.Employees
(
  empid VARCHAR(10) NOT NULL,
  salary MONEY NOT NULL,
  filler CHAR(2500) NOT NULL DEFAULT('a')
);

CREATE CLUSTERED INDEX idx_cl_salary ON dbo.Employees(salary);
ALTER TABLE dbo.Employees
  ADD CONSTRAINT PK_Employees PRIMARY KEY NONCLUSTERED(empid);

INSERT INTO dbo.Employees(empid, salary) VALUES('A', 2000.00);
INSERT INTO dbo.Employees(empid, salary) VALUES('B', 4000.00);
INSERT INTO dbo.Employees(empid, salary) VALUES('C', 3000.00);
INSERT INTO dbo.Employees(empid, salary) VALUES('D', 1000.00);
GO