Answer / guest

There are basically two types of indexes that we use with
the SQL Server. Clustered and the Non-Clustered.

Answer / nagabhushan

Indexes are of two types,Clustered Index and non Clustered
Index,when you create Clustee index on tables all the rows
in the tables are stored in the order of the clustered
Index key,So there will one cluster index in the table.Non
Clustered Index have there own storage seperate from the
table data storage.Non Clustered Index is stored in the
form of B-trees.

Can a table be created inside a trigger?

0 Answers  

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

how to change column into row in sql

4 Answers   ESS,

---

How many databases instances are there in sql server 2000?

0 Answers  

---

Alternative way to DetDate() function?

5 Answers  

---

---

What is tempdb in sql server?

0 Answers  

---

Explain syntax for dropping triggers?

0 Answers  

---

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

---

What is a bit datatype?

0 Answers  

---

What are the different types of cursor?

0 Answers   HCL,

---

Detail about query optimizer?

0 Answers  

---

How many levels of sp nesting is possible?

0 Answers  

---