O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Review Questions

  1. You are concerned about poor performance of a table in your database that users are running range queries on. You have queried sys.dm_db_index_physical_stats and discovered that the avg_fragmentation_in_percent value for the table's index is 75. You have also run DBCC SHOW_STATISTICS and noticed that they have not been updated for a week. What should you do to improve performance?
    1. Update the statistics.
    2. Defrag the index.
    3. Drop and create the statistics using a full scan.
    4. Rebuild the index.
  2. You are responsible for managing 100 SSRS instances in your organization. You want to make a configuration change on all the SSRS instances. What is the best tool to achieve this?
    1. rs.exe
    2. rsconfig.exe
    3. SQL Server Configuration Manager
    4. Reporting ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required