Answer / vikram

Clustered index hold data at the leaf node.
non clustered hold data location (pointer) at the leaf node.
when we create primary key Clustered index automatically
created

Answer / hari

cluster Index create leaf level of (actul data) data.
Non-cluster Index create pointer level of data.

Answer / rajkumar

There can be only 1 Clustered index in a table

where as nonclustered index can be upto 249

Clustered is physical sorted index..

non clustered is logical stored index is faster than
clustered index

thats all i know

Answer / manisha

cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.

a table can have max of 1 clustered index but can have upto
249 non clustered index.

select names starts with a,b,c

8 Answers   Scope International,

---

What are the tables in sql?

1 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1 Answers   HCL, Wipro,

---

What is sql server transaction log file?

1 Answers  

---

What is the difference between a function and a stored procedure?

1 Answers  

---

Explain the properties of subqueries in sql server?

1 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---

What are the default system databases in sql server 2000?

1 Answers  

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---

can you any body tell me which service pack is installed in the sql server?

3 Answers  

---