What is data compression?

1 Answers  

---

Define inner join? Explain with an example?

1 Answers  

---

What are the types of subquery?

1 Answers  

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

Is there any difference between the primary key and unique key?

1 Answers  

---

What is Service Broker in sql server 2012?

1 Answers   UGC Corporation,

---

Why is the need for data conversion transformations?

1 Answers  

---

What are the types of indexes?

1 Answers  

---

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---

What is de-normalization and when do you do it?

3 Answers  

---

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

1 Answers   G7 CR Technologies, IBM, Satyam,

---

How many types of stored procedures are there in sql server?

1 Answers  

---