Difference between Cluster and Non-cluster index?
Answer Posted / kenatrivedi
Clustered Index is Clustered Index
Non-cluster Index is Non-cluster
Is This Answer Correct ? | 61 Yes | 255 No |
Post New Answer View All Answers
how will add additional conditions in sql?
How many clustered indexes there can be on table ?
Explain transaction server consistency?
Do you know how to store and query spatial data?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is a transact-sql statement batch in ms sql server?
How to use "begin ... End" statement structures in ms sql server?
Mention the command used to rename the database.
Do you know what is replace and stuff function in sql server?
What is data block and how to define data block size?
What is a transaction and why is it important?
Explain active/passive and active/active cluster configurations?
what is a check constraint?
Tell me what are cursors and when they are useful?