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)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16131092/viewspace-2125612/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16131092/viewspace-2125612/