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? : Sql server administration

0 Answers  

---

What do you understand by triggers?

0 Answers  

---

What happens to a trigger with multiple affected rows?

0 Answers  

---

What is the difference between a local and a global temporary table?

0 Answers  

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---

What is index?

1 Answers   Cap Gemini,

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

What do you understand by mirroring?

0 Answers  

---

Explain having clause and where clause?

0 Answers  

---

What are the ways available in sql server to execute sql statements?

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  

---

What triggers long term care?

0 Answers  

---