题目内容

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.

查看答案
更多问题

抗战期间,思想界的争论有哪些?

RC4切丝机砂轮往复机构组成部分是什么?

水是维持人体正常生理活动的重要物质,人体缺水后会导致人体机能下降,如果失去体内水分(),就会危及生命。

A. 10%
B. 20%
C. 30%

硅酸盐水泥熟料的主要化学成分有哪些?

答案查题题库