Difference between Cluster and Non-cluster index?
Answer Posted / helps
The index one sees in the beginning of a book is a
clustered index and the index one sees at the end of the
book is a non clustered index.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What is “asynchronous” communication in sql server service broker?
When do you think a developer should use sql server-based cursors?
What are the default system databases in sql server 2000?
What is the difference between inner join and equi join?
How do I create a partition table in sql server?
What do you understand by intent locks?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What are the tool windows in sql server management studio? : sql server management studio
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
How can delete duplicate records in cte in sql server?
What information is maintained within the msdb database?
Explain how to maintain a fill factor in existing indexes?
Describe how to use the linked server?