Answer Posted / guest

A method for automate the routine task.

Is it possible to replicate data from sql server to oracle? : sql server replication

1133

---

What are scalar functions?

1046

---

How to fine-tune reports?

279

---

Explain foreign key in sql server?

1069

---

How will you optimize a stored procedure optimization?

1107

---

What is sql server english query?

1193

---

What methods do you follow to protect from sql injection attack?

1070

---

What are truncate options available in sql server? : sql server database administration

1074

---

How do I find the sql server database version?

1047

---

Explain the steps to create and execute a user-defined function in the sql server?

1013

---

What is a data source or ds? : sql server analysis services, ssas

1049

---

what is dbcc? : Sql server database administration

1075

---

What is a trigger? Why we need it?

1048

---

List out the different types of locks available in sql server?

1025

---

Does the order of columns in update statements matter?

954

---