Interested to Buy Any Domain ? << Click Here >> for more details...
Difference b/w Clustered & non-clustered index? Not the
bookish definition, but how they internally works in SQL Server?
- 1 Answers
- 5760 Views
- United Healthcare, I also Faced
- E-Mail Answers
Answer Posted / anand vanam
•In clustered Index leaf node contains the actual data pages
where as in Non clustered index leaf node contains index
pages.
•You can have only one clustered index per table but you can
have 249 Non clustered indexes per table as per SQL 2005
(999 in SQL 2008)
•The row locator in clustered index is the Clustered Index
Key where as in Non clustered index row locator is a pointer
to the row.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Do you know sql server 2008 introduces automatic auditing?
what is the system function to get current user's user id? : Sql server database administration
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What do you understand by sql server agent?
Why should one not prefix user stored procedures with ‘sp_’?
Do you know clustered and non-clustered index?
Where can you add custom error messages to sql server?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is ddl command?
Name some of the open source software that you can use in alternative to SSR?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
If we delete pack Spec what will be the status of pack Body ?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What do you understand by the denormalisation?
What is the use of floor function in sql server?
