Explain filtered indexes?

0 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

Can you explain different types of locks in sql server?

0 Answers  

---

What do you understand by hotfixes and patches in sql server?

0 Answers  

---

What is the maximum size per database for sql server express?

0 Answers  

---

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

---

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  

---

Which sql server is best?

0 Answers  

---

what is sql server? : Sql server database administration

0 Answers  

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---