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 the maximun sixes of .mdf in sql server 2005

1 Answers  

---

What is updatable resultset?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

---

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

0 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

---

What is instead of trigger sql server?

0 Answers  

---

Explain filtered indexes?

0 Answers  

---

What is the difference between OLEDB and ODBC

4 Answers   CFCI,

---

what is nonclustered index

0 Answers  

---

1 01 101 01010

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What is a user-defined function in the sql server and what is its advantage?

0 Answers  

---