DBCC EXTENTINFO 的学习（未完）

USE master
GO
IF DB_ID(N'Index_Demo') IS NOT NULL
 DROP DATABASE Index_Demo
CREATE DATABASE Index_Demo
GO
use Index_Demo
GO --create a heap table
IF OBJECT_ID(N'Index_One','U') IS NOT NULL
 DROP TABLE Index_One
CREATE TABLE Index_One
 (
   ID INT IDENTITY(1,1),
   DATA CHAR(8000)
  )
GO
INSERT INTO Index_One DEFAULT VALUES
GO 4 --2008 new function, start 4 transaction, loop 4 times --select * from Index_One
DBCC EXTENTINFO(0,Index_One,-1)