Where cross join is used?

0 Answers  

---

Can we use max in where clause?

0 Answers  

---

What is partition index in sql server?

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

How to provide values to user defined function parameters?

0 Answers  

---

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---

Explain multiserver query

0 Answers  

---

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

---

What do you understand by the denormalisation?

0 Answers  

---

What language is sql server written in?

0 Answers  

---

Define left outer join?

0 Answers  

---