What is index fragmentation in ms sql server?


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

Post New Answer

More SQL Server Interview Questions

What is simple indexing method?

0 Answers  


What is the syntax for encrypting a column in SQL Server?

0 Answers   MindCracker,


What is Right Outer Join?

2 Answers  


Do you know the capabilities of cursors?

0 Answers  


What do you mean by cardinality?

0 Answers  






If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,


Why can there be only one clustered index and not more than one?

0 Answers  


Explain what are the authentication modes in sql server?

0 Answers  


How to provide default values to stored procedure parameters?

0 Answers  


Can an automatic recovery be initiated by a user?

0 Answers  


What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers  


What are the recovery models in sql server 2000?

0 Answers  


Categories