Difference b/w Clustered & non-clustered index? Not the
bookish definition, but how they internally works in SQL Server?
Answer / 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 |
What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.
How to find the last update record in SQL Server?
Explain for xml explicit mode?
Which institute is best for SQL Server 2005 Training?
What is bcnf normalization form?
what are constraints? Explain different types of constraints? : Sql server database administration
What is a synonym for manipulation?
What is a data source file?
What is a schema in ms sql server 2005?
How to turn off warning messages during php execution?
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?
what is the cursor life span?