SQL Server 2008 编程入门经典第9章练习题
EXEC sp_helpindex 'HumanResources.Employee' 如下: USE AdventureWorks2008 ; SELECT * FROM sys.dm_db_index_physical_stats(DB_ID(N…
EXEC sp_helpindex 'HumanResources.Employee' 如下: USE AdventureWorks2008 ; SELECT * FROM sys.dm_db_index_physical_stats(DB_ID(N…
SET @db_id = DB_ID(N'AdventureWorks'); SET @object_id = OBJECT_ID(N'AdventureWorks.Sales.SalesOrderDetail'); SELECT database_id, object_id…
ALTER INDEX PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID ON Sales.SalesOrderDetail REBUILD WITH (FILLFACTOR = 100)