How can you check the level of fragmentation on a table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is the difference between local and global temporary tables?

0 Answers  


Does an index slow down updates on indexed columns?

0 Answers  


What is ddl command?

0 Answers  


What is public role in sql server?

0 Answers  


Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,






What is indexed view? How to create it?

0 Answers  


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  


How many types of schemas are there?

0 Answers  


What is the difference between system objects and user objects?

0 Answers   HCL,


Define synonym?

0 Answers  


Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  


What is the recovery model? List the types of recovery model available in sql server?

0 Answers  


Categories