Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Your manager has asked you to check the index stats for a particular table called Address. You have executed the following query (see below) and it reported that the avg_fragmentation_in_percent is 15%. What should you do?
SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'Test'), OBJECT_ID(N'Address'), NULL, NULL , 'DETAILED');
on 7/30/2014 | Category:
Sql Server Interview questions
| Views: 556 |
Select from following answers:
Run ALTER INDEX REBUILD WITH (ONLINE = ON)
Run ALTER INDEX REORGANIZE
Rebuild the table
Nothing, the index fragmentation is at a safe level
Generally, you should reorganize indexes if the fragmentation is between 5 and 30 percent. You should rebuild the index if the fragmentation is over 30 percent. Remember, these values provide a rough guideline for determining the point at which you should switch between ALTER INDEX REORGANIZE and ALTER INDEX REBUILD. However, the actual values may vary from case to case. It is important that you experiment to determine the best threshold for your environment.
Show Correct Answer
Many Interviews |
< Previous :
You need to delete a stored procedure from the SQL ...
Next > :
Which of the following CANNOT be passed back as an ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Which of the following CANNOT be passed back as an output parameter fr ...
Which of the following generates control-breaks and subtotals in the r ...
You've created a simple select statement that returns the customer ...
Your manager has asked you to design a new table and enforce rules for ...
which of the following SP will be useful to show the active user conne ...
One of the developers at your company has written a CLT stored procedu ...
Side by side upgrades are a common choice when installing SQL 2008 alo ...
Your manager has asked you to create a new user on SQL Server 2008 tha ...
Latest Interview Questions
By default,Asp.Net stores SessionIDs in which mechanism?
In order to prevent a browser from caching a page which of the stateme ...
We have defined one page_load event in aspx page and the same is defin ...
How to display a computer code in html
What is the FEATURES or PURPOSE of Raise Error?
Can a Clustered Index ALSO be a Unique Index?
Which statement is used for defining a Cursor?
Which Process is used for Maintaining State Server Session in Asp.Net ...