Do you know what is user defined datatypes and when you should go for them?

0 Answers  

---

Explain the properties of subqueries in sql server?

0 Answers  

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

Why union all is faster than union?

0 Answers  

---

Wht is Stuff in sql ser

2 Answers  

---

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

What structure can you implement for the database to speed up table reads?

0 Answers  

---

How you can minimize the deadlock situation?

0 Answers  

---

How do you create a clustered index?

0 Answers  

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

0 Answers  

---

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

---

In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  

---