How can you check the level of fragmentation on a table?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between local and global temporary tables?
Does an index slow down updates on indexed columns?
What is ddl command?
What is public role in sql server?
Hi..here i would like to know the Backup and Restore models?
What is indexed view? How to create it?
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?
How many types of schemas are there?
What is the difference between system objects and user objects?
Define synonym?
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?
What is the recovery model? List the types of recovery model available in sql server?