SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 790 Page Views: 

Which SQL Statement is used to show fragmentation information for data and indexes of the specified table?



Posted By: Avi Date: 1 October 2010 12:28:08 PM
 Answer:

DBCC SHOWCONTIG.


Posted By: avibtech


Date: 1 October 2010 12:28:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image vsMMMK
Related Questions
SQL Server : What is the purpose of the locks in SQL Server?

What is the purpose of the locks in SQL Server?

Category: SQL Server Date: 10/1/2010 11:12:07 AM
SQL Server : Usually clustered and non-clustered indexes are discussed. It can be further configured into three categories. Which are those?

Usually clustered and non-clustered indexes are discussed. It can be further configured into three c....

The three ways other than clustered and non-clustered it can be configured into Composite Index and ....
Category: SQL Server Date: 10/1/2010 11:11:07 AM
SQL Server : There are several advantages of creating and index , but can you state some drawbacks of creating an index?

There are several advantages of creating and index , but can you state some drawbacks of creating an....

There are major two drawbacks of using indexes. 1.First one is the disk space. Index uses much spac....
Category: SQL Server Date: 10/1/2010 11:10:07 AM
SQL Server : What is the purpose of creating an index?

What is the purpose of creating an index?

The indexes in SQL server are similar to the indexes of the books.When no index is used for searchin....
Category: SQL Server Date: 10/1/2010 11:09:07 AM
SQL Server : What is an index?

What is an index?

Index is a way of finding out data quickly based on the values in the columns. Indexes are created o....
Category: SQL Server Date: 10/1/2010 11:08:07 AM