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 use linked server?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

What are the steps you should follow to start sql server in single-user mode?

0 Answers  

---

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

---

What is the difference between a view and a stored procedure?

0 Answers  

---

What is the difference between mysql and sql server?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

What is the difference between dataadapter and datareader?

0 Answers  

---

Why would you use sql agent?

0 Answers  

---

Does group by sort data?

0 Answers  

---

Can you move the resources after pausing the node? : sql server database administration

0 Answers  

---