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.

how to avoid cursors? : Sql server database administration

0 Answers  

---

Can I save my report as html, excel or word? : sql server management studio

0 Answers  

---

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

---

What is partition index in sql server?

0 Answers  

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  

---

What is spatial and temporal data?

0 Answers  

---

Can we check locks in database? If so, how can we do this lock check?

0 Answers  

---

Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

---

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

---

What is data source view or dsv? : sql server analysis services, ssas

0 Answers  

---