What is difference between view and materialized view?

0 Answers  

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  

---

How to use subqueries in the from clause in ms sql server?

0 Answers  

---

Please explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

---

How to perform backup for certificates in sql server? : sql server security

0 Answers  

---

Explain ms sql server reporting services vs crystal reports?

0 Answers  

---

How do I view a stored procedure in sql server query?

0 Answers  

---

Alternative way to DetDate() function?

5 Answers  

---

What do you understand by triggers?

0 Answers  

---

How do you rebuild an identity column?

0 Answers  

---

Explain important index characteristics?

0 Answers  

---