LISTING 1: Creates a One-Page Table with Large and Small Rows

/* First create the table. */
USE pubs
GO
DROP TABLE splitrows
GO
CREATE TABLE splitrows
(
    a int  primary key,
    b varchar(1600)
)
GO
/* Insert four large rows and four small rows into the table. */
INSERT INTO splitrows 
    VALUES (5, REPLICATE('a', 1600)) 

INSERT INTO splitrows 
    VALUES (10, replicate('b', 1600)) 

INSERT INTO splitrows 
    VALUES (15, replicate('c', 1600)) 

INSERT INTO splitrows 
    VALUES (20, replicate('d', 1600)) 

INSERT INTO splitrows 
    VALUES (25, replicate('e', 16)) 
GO

INSERT INTO splitrows 
    VALUES (30, replicate('f', 16)) 
GO
INSERT INTO splitrows 
    VALUES (35, replicate('g', 16)) 
GO
INSERT INTO splitrows 
    VALUES (40, replicate('h', 16)) 
GO