What is the sql server agent?

0 Answers  

---

What is a transactions?

0 Answers  

---

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

What do you know about normalization and de- normalization?

0 Answers  

---

How do you create an execution plan?

0 Answers  

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

Mention the command used to rename the database.

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 group by be used without aggregate functions?

0 Answers  

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

Can I delete event logs?

0 Answers  

---