How to create indexed view?

0 Answers  

---

Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,

---

Tell me what are the advantages of using stored procedures?

0 Answers  

---

what are database files and filegroups? : Sql server database administration

0 Answers  

---

What do you mean by an execution plan?

0 Answers  

---

---

What is difference between rownum and row_number?

0 Answers  

---

How to start and end transact-sql statements?

0 Answers  

---

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

What is data integrity? Explain constraints?

1 Answers   Thinksoft,

---

How to modify the underlying query of an existing view?

0 Answers  

---

Explain cdc and sql injection?

0 Answers  

---