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

1 Answers  

---

What are page splits? : SQL Server Architecture

0 Answers  

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---

What is temporary stored procedure?

0 Answers  

---

What is set nocount on?

0 Answers  

---

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

0 Answers  

---

What is unique key constraint?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

Why is the need for data conversion transformations?

0 Answers  

---

What is @@rowcount in sql?

0 Answers  

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---