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?
Update the statistics.
Defrag the index.
Drop and create the statistics using a full scan.
Rebuild the index.
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?
SQL Server Configuration Manager
With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, interactive tutorials, and more.