Difference b/w Clustered & non-clustered index? Not the
bookish definition, but how they internally works in SQL Server?

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they intern..

Answer / anand vanam

•In clustered Index leaf node contains the actual data pages
where as in Non clustered index leaf node contains index

•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

More SQL Server Interview Questions

how do we find every fifth record in a table

14 Answers   Aspire, HCL,


3 Answers   Karur Vysya Bank KVB,

plz send every query in sql server2000

1 Answers   Infosys,

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

What is the use of DBCC commands?

4 Answers  

what is a stored procedure and trigger?

3 Answers  

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

what are the critical issues you have resloved in your company

0 Answers   Wipro,