Answer / Chhaya Goswami

Join operations are generally slower than UNION in SQL Server because they require matching rows between two tables based on specified conditions. UNION simply concatenates the results of multiple SELECT statements, making it quicker when the focus is on combining rows without much filtering.

Can sql servers linked to other servers?

1 Answers  

---

What are the disadvantages of using the stored procedures?

1 Answers  

---

What part does database design plays a role in performance of an sql server-based application?

1 Answers  

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

1 Answers  

---

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

1 Answers  

---

How to create a new schema in a database?

1 Answers  

---

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

1 Answers  

---

What is an indexing strategy?

1 Answers  

---

What are the benefits of normalization?

1 Answers  

---

can you any body tell me the how to decrease the logfile

4 Answers  

---

What is the difference between index seek vs. Index scan?

1 Answers  

---

Explain sp_configure commands, set commands?

3 Answers  

---