How to rebuild indexes with alter index ... Rebuild?

0 Answers  

---

Explain what are magic tables in sql server?

0 Answers  

---

What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---

What is a scheduled job or what is a scheduled task?

0 Answers  

---

---

what are batch in sql server?

2 Answers   Satyam,

---

What are the different types of replication are there in sql server 2000?

0 Answers  

---

What is indexing explain it with an example?

0 Answers  

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

What is Trigger?

3 Answers   Misys,

---

What is the difference between having clause and where clause in sql server?

0 Answers  

---

Characterize join and name diverse sorts of joins?

0 Answers  

---