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.

How to define output parameters in stored procedures?

0 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

Explain how to send email from sql database?

0 Answers  

---

What are the main sources of data?

0 Answers  

---

What is a deadlock and what is a live lock?

0 Answers  

---

How except clause is differs from not in clause?

0 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

---

optimization techinques

0 Answers   Wipro,

---

What are the operating modes in which database mirroring runs?

0 Answers  

---