You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. Your job is to manage a SQL Server 2005 database, and there are several indexes in the SQL Server 2005. A stored procedure should be written, and the procedure should be utilized to check the indexes for fragmentation. From the following four Transact-SQL statements, which one should be utilized achieve the goal?()
- A、To achieve the goal, DBCC DBREINDEX should be utilized.
- B、To achieve the goal, SELECT * FROM sys.indexes should be utilized.
- C、To achieve the goal, SELECT * FROM sys.dm_db_index_physical_stats should be utilized.
- D、To achieve the goal, DBCC INDEXDEFRAG should be utilized.
正确答案:C
答案解析:有
微信扫一扫手机做题