Answer / pandian

There are two types of indexs.
1. Cluster Index (Ex. Primary Key)
2. Non Cluster Index(Ex.Unique Key)

Answer / bala

Filtered Index in case of SQL Server 2008

What is dirty read?

0 Answers  

---

can an automatic recovery be initiated by a user? : Sql server administration

0 Answers  

---

What is the difference between mysql and mysqli?

0 Answers   HCL,

---

How to execute a sql statement using mssql_query()?

0 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

0 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

How to list all user defined functions in the current database?

0 Answers  

---

What are the different types of columns types constraints in the sql server?

0 Answers  

---

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

---

What is an indice?

0 Answers  

---

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

---