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

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

What are cursors?

8 Answers  

explain query execution plan

1 Answers  

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

what is DTS what are tasks available

1 Answers   Wipro,

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

15 Answers   Accenture, IBM, Marlabs,

Anyone please explain me the concept of Serialization?

3 Answers  

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,