Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
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?
on 11/21/2013 | Category:
Sql Server Interview questions
| Views: 9897 |
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
In that case we should reorganize the indexes of the table
Show Correct Answer
Many Interviews |
< Previous :
If you have ON DELETE CASCADE statement to the for ...
Next > :
Which is social features introduced in SharePoint ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
How to limit the results to include only the top 100 most recent recor ...
CREATE TABLE employee ( id_num int IDENTITY(100,10), fname varchar (20 ...
which one of the following is suitable for writing a new query that wi ...
Which of the following statement is TRUE regarding INSTEAD OF triggers ...
How to generate grand total for the total column as a separate result ...
Which of the following datepart argument is used to get the MINUTE val ...
What is the output of select ISNULL(10, getdate()) as 'IsNullWithD ...
What is the output of select COALESCE(10, getdate()) as 'COALESCE& ...
Latest Interview Questions
Which is social features introduced in SharePoint 2010?
How to find Gridview's Control in RowDataBound event?
Gridview's SelectedRow property is used for which gridview' ev ...
What is the difference between BDC and BCS?
What is Gridview_SelectedIndexChanged and Gridview_RowCommand events i ...
Which Gridview events called first?
In which Gridview Events,We change Label(inside gridview) text or fill ...