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 master database? : SQL Server Architecture
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?
what is Buffer cash and Log Cache? Can you Explain it?
Explain left outer join and right outer join?
Define cursor locking
What do you mean by an execution plan?
How do you size a resultset?
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..
17 Answers 3i Infotech, Rolta, TCS,
How to integrate the ssrs reports in application?
How to insert a new row into a table with "insert into" statements in ms sql server?
What is primary key index?
What are the types of model in sql server and explain