Page Split DBCC SQL Code

This is from QOD40. Remember that even a ROLLBack causes a page split.

create table test ( c1 int , c2 varchar(1000))create

insert into test values (1, REPLICATE('a' , 900))insert into test values (2, REPLICATE('b' , 900))insert into test values (3, REPLICATE('c' , 900))insert into test values (4, REPLICATE('d' , 900))insert into test values (6, REPLICATE('f' , 900))insert into test values (7, REPLICATE('g' , 900))insert into test values (8, REPLICATE('h' , 900))insert into test values (9, REPLICATE('i' , 900))dbcc
begin
insert tran into test values (5, REPLICATE('e' , 900))rollback tran ind(0, 'test' , 1) clustered index pk on test(c1)