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.

Write a sql query to display the current date?

0 Answers  

---

What are the disadvantages of using querystrings to send data from one page to another?

0 Answers  

---

How you can move data or databases between servers and databases in sql server?

0 Answers  

---

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

0 Answers  

---

Define primary key?

0 Answers  

---

---

Ms sql server index?

0 Answers  

---

What is index, cluster index and nonclustered index?

0 Answers  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

What action plan is preferred if sql server is not responding?

0 Answers  

---

Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,

---

Explain full-text query in sql server?

0 Answers  

---

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

---