Answer / clara

 How will you check if a stored procedure with 500 line of code is running very slow? What steps will you take to optimize it?

Is the company liable to deduct professional tax of directors?

1 Answers  

---

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

1 Answers  

---

what is meant by write off and write on in sap?

5 Answers   Reliance Communications, Wipro,

---

How to solve "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics" error.

1 Answers   TCS,

---

Difference between Bookmark lookup & RID lookup?

1 Answers  

---

On which table the SSIS SQL Server logs are stored?

1 Answers  

---

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

1 Answers  

---

What is live lock, deadlock and what is Lock escalation?

1 Answers  

---

How will you Handle Error in SQL SERVER 2008?

1 Answers  

---

What is Mutex error in Triggers?

1 Answers  

---

How to view the error log for any specific instance?

1 Answers  

---

What is the use of NOLOCK locking hint?

1 Answers  

---