Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

---

What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---

How to count the number of duplicate items in a table?

3 Answers  

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

What is amo? : sql server analysis services, ssas

0 Answers  

---

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

---

What are the two modes of authentication in sql server?

0 Answers  

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

---

How to execute a sql statement using mssql_query()?

0 Answers  

---

What are the different index configurations a table can have?

0 Answers  

---

How to resolve the orphan use problem? : sql server security

0 Answers  

---