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.

When should you use an instead of trigger?

0 Answers  

---

from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers  

---

Which system tables contain information on privileges granted and privileges obtained

1 Answers  

---

What is the difference between upgrade and migration in sql server?

0 Answers  

---

Explain system views?

0 Answers  

---

---

How to link up the text file to a Database table?

2 Answers   Allianz,

---

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

---

After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  

---

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

---

How to create a view with data from multiple tables?

0 Answers  

---

Can we write trigger for view?

0 Answers  

---