What command is used to create a database in the sql server and how?

0 Answers  

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

---

What is data block and how to define data block size?

0 Answers  

---

Explain the advantages of merge replication?

0 Answers  

---

---

Define normalisation?

0 Answers  

---

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

7 Answers  

---

Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---

What is the stuff and how does it differ from the replace function?

0 Answers  

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---