Difference b/w Clustered & non-clustered index? Not the
bookish definition, but how they internally works in SQL Server?
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
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Explain the first normal form(1nf)?
How to create a new login name in ms sql server?
What are the advantages of using a stored procedure?
How global temporary tables are represented and its scope?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
When you should use a low fill factor?
Define Wed Edition in SQL Azure?
When do you think a developer should use sql server-based cursors?
What is a data source or ds? : sql server analysis services, ssas
How to use “drop” keyword in sql server and give an example?
Is sql server a database?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is unpivot?
What will happen if a column containing char type data is changed to the nchar data type?