Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vikram
Clustered index hold data at the leaf node.
non clustered hold data location (pointer) at the leaf node.
when we create primary key Clustered index automatically
created
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What are “lost updates”?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What are the built in functions in sql server?
What is sub-query in sql server?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is table value parameters (tvp)?
What are the difference between primary keys and foreign keys?
explain different types of constraints? : Sql server database administration
When I run the sql server 2000 setup, it just hangs. What do I do?
What are the advantages to use stored procedures?
What is change data capture (cdc) feature?
What are the different types of Indexes available in SQL Server?
What is ms sql server service broker?
How to fetch the next row from a cursor with a "fetch" statement?
