What is the basic difference between clustered and a
non-clustered index?
Answer Posted / meera
Clustered index is unique for a table and 249 non-clustered
can be created.The leaf contains data and in non-clustered
the keaf node contains reference to the data.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
List some of the rules that apply to creating and using a ‘view’
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What is a partitioned view?
Explain the various types of concurrency problem?
What is xdr?
What are the export options of ssrs?
Do you know what are pages and extents? : SQL Server Architecture
What is NOT NULL Constraint in sql server 2012?
What are sp_configure commands and set commands?
What happens if null values are involved in string operations?
what are triggers? : Sql server database administration
What is sql injection and why is it a problem? : sql server security
How to access the inserted record of an event?
How column data types are determined in a view?
How to use “drop” keyword in sql server and give an example?