Answer / anindya basu

An indexed view is a part of the database and is saved to the disc. Creating an index on a view turns the latter into a permanent database object since indexes are so. Consequently every time the view is invoked, it gets loaded from the disc and need not be recreated.

Why is replication required on the sql server?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

how do u find least salary in a table

4 Answers  

---

Which system tables contain information on privileges granted and privileges obtained

1 Answers  

---

What is the difference between for trigger and after trigger?

0 Answers  

---

How to provide values to user defined function parameters?

0 Answers  

---

what is a deadlock? : Sql server database administration

0 Answers  

---

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

---

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

What is Inner Join?

2 Answers  

---

What is GUID in sql server?

0 Answers   BirlaSoft,

---