SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'study'), OBJECT_ID(N'EMPLOYEEs'), NULL, NULL , 'DETAILED');

What you should do if a table (employees) has very less average fragmentation (avg_fragmentation_in_percent) value?

 Posted by Bandi on 11/21/2013 | Category: Sql Server Interview questions | Views: 12025 | Points: 40
Select from following answers:
  1. Run ALTER INDEX REBUILD WITH (ONLINE = ON)
  2. Run ALTER INDEX REORGANIZE
  3. Rebuild the table
  4. Nothing, the index fragmentation is at a safe level
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response