Overview recently to share a courseware to re-organize this piece of knowledge, a bit long, want to understand the thorough or to the computer practice. Body Aggregation Index 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
22--Create a test database ixdata go use [ixdata] go---Create Test table creation table Orders (ID INT PRIMARY KEY IDENTITY), NAM E CHAR (n) is not NULL, IDATE DATETIME is not null DEFAULT (GETDATE ())); GO---Insert 1000 test data DECLARE @ID int=1 while (@ID <=1000) BEGIN insert INTO Orders (NAME) VALUES (' Commodity ' +convert (NVARCHAR (20), @ID)) SET @[email protected]+1 END Go SELECT * from Orders GO Parse page information for newly created table 1 2 3 4 5 6 7 8---Display the status of the trace flag DBCC tracestatus- --Turn on trace flag DBCC TRACEON (3604,2588)--dbcc traceoff (3604,2588)---Gets the data page of the object, structure: Database, object, display DBCC IND (ixdata,orders,-1)
This article selected from Hot Rice forum
SQL Server data store