Listing 1: Enable Traceflag 1118 to Avoid Using Mixed Extents USE tempdb GO DROP TABLE largerow GO DBCC TRACEON(1118) GO CREATE TABLE largerow (a int identity, b char(8000) default 'No data' ) GO DECLARE @rows int SET @rows = 1 WHILE @rows < 9 BEGIN INSERT INTO largerow DEFAULT VALUES SET @rows = @rows + 1 END GO Begin Callout A DBCC EXTENTINFO(tempdb, largerow, -1) GO End Callout A