Can we create clustered index on non primary key column
Answer Posted / madhav
yes we can create clusterd index on non primary key. but
the primary key must should be a non clusteresd index
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain hostprotectionattribute in sql server 2005?
What is a result set object returned by odbc_exec()?
What is the purpose of object explorer and its features? : sql server management studio
What is change data capture (cdc) feature?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What is side by side migration in sql server?
What are various limitations of the views?
What is fill factor and pad index?
Explain timestamp datatype?
How important do you consider cursors or while loops for a transactional database?
How to create a trigger for insert only?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is acid properties?
What are the properties of the transaction?
Differentiate between delete and truncate.