What is Fragmentation and Defragmentation? For 32GB
Table,How can we do the fragmentation?



What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?..

Answer / aina

go to start and click fragment

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is the difference between grant and with grant while giving permissions to the user?

0 Answers  


What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,


Write query to return all rows sql?

0 Answers  


how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

0 Answers  






Write a code to select distinct records without using the DISTINCT keyword.

0 Answers   Aspiring Minds,


What are the two modes of authentication in sql server?

0 Answers  


What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,


What is the difference between temp table and table variable?

8 Answers   Microsoft,


What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,


What is a DBMS, query, SQL?

0 Answers   Maveric,


Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,


Categories