Answer / karthikeyathirughanashamphanth

Step-1:Capturing Performance metrices.
Step-2:Find the problem Queries with Profiler.
Step-3:Define Mitigation for the Problem Queries.

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

---

What is 2nf normalization?

0 Answers  

---

How many primary keys are possible in a table?

0 Answers  

---

About DTS usage ?

2 Answers   Cognizant, Wipro,

---

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 Answers  

---

---

What is a transactions?

0 Answers  

---

Explain system views?

0 Answers  

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  

---

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  

---