可学答题网 > 问答 > MCTS(70-431)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You manage a SQL 


You manage a SQL Server 2005 database that contains a table with many indexes.  You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use?()

  • Asys.dm fts index population
  • Bsys.dm exec query stats
  • Csys. dm db index usage stats
  • Dsys.dm db index physical stat
参考答案
参考解析:
分类:MCTS(70-431)题库
相关推荐

1、You manage a server&en

You manage a server named Server2 that runs Windows Server 2008. You install and test the&...

2、You manage a server&en

You manage a server that runs Windows Server 2008. The server has the Web Server (IIS)&e...

3、You manage a member&en

You manage a member server that runs Windows Server 2008. The server runs the Terminal Ser...

4、You manage a server&en

You manage a server that runs Windows Server 2008. You have installed the Windows SharePointSer...

5、You manage a member&en

You manage a member server that runs Windows Server 2008. The server has the Terminal Serv...

6、连接式“2+3”&“=”&(2+3)的运算结果为( )。 A

连接式“2+3”&“=”&(2+3)的运算结果为( )。 A.“2+3=2+3” B.“2+3=5” C.“5=5” D.“5=2+3”A“2+3=2+3” B“2+3=5” C“5=5” D“5=2+3”