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 create a simple stored procedure in ms sql server?

0 Answers  

---

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---

What are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

Explain different types of collation sensitivity?

0 Answers  

---

What are the two types of concurrency?

4 Answers  

---

What is mean by "fill factor" ? and what is mean by "Index "in sql?

1 Answers   iGate, Logica CMG,

---

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

Explain the usage of floor function in sql server.

0 Answers  

---

What is temporary stored procedure?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

---