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.

what is database replicaion? : Sql server database administration

0 Answers  

---

What is the latest version of microsoft sql server?

0 Answers  

---

What is the difference between rank and dense_rank?

0 Answers  

---

How to receive returning result from a query?

0 Answers  

---

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  

---

What is the maximum size of column in sql server?

0 Answers  

---

what is an extended stored procedure? : Sql server database administration

0 Answers  

---

Can we hide the definition of a stored procedure from a use?

0 Answers  

---

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

---

What is a periodical index?

0 Answers  

---

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

---