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 you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

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  

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

on line cluster can we make if yes tell me the procedure

0 Answers   Microsoft,

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

How can you see what type of locks used?

1 Answers  

What's the difference between a primary key and a unique key?

4 Answers  

What command do we use to rename a db?

5 Answers