Answer / s.panda

Step1: At first we need to identified the high load SQLs or
top SQLs that are responsible for performance problem or in
another word the sql that consume application workload and
system resources. We can easily identify them by reviewing
past SQL execution history available in the system.

Step 2: Now generate execution plan of those high load sql
statements and verify that the execution plans produced by
the query optimizer for these statements perform reasonably.

Step 3: Implement corrective actions to generate better
execution plans for poorly performing SQL statements. While
taking corrective actions there is many considerations.

Is a table valued function object?

0 Answers  

---

Is primary key clustered or nonclustered?

0 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

What is meaning of <> in sql?

0 Answers  

---

How do you delete a table?

0 Answers  

---

---

What is a data manipulation language?

0 Answers  

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---

what is collation? : Sql dba

0 Answers  

---

Explain normalization and what are the advantages of it?

0 Answers  

---

what are all types of user defined functions? : Sql dba

0 Answers  

---

What is rank function in sql?

0 Answers  

---

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---