Answer / visala

first we have to check indexes are there or not,
check whether the statistics are updated or not,
check fragmentation is there or not,
check availability of joins,
check availability of aggregatefnctions,
may be networking problem,
may be hardware problem

then we tunne according to these problems

Answer / shivaraj

it is depends on
Data base design.
Hardware Sizing,
Application T- SQL codes- Indexes,Stored
Procedues,constraints
no of clients
no users
Type of data and Quantity base storage capacity on daily
basis

When would you prefer to have a minimum number of indexes?

0 Answers  

---

How to execute multiple stored procedures at one time in sql server?

0 Answers  

---

Can we perform backup restore operation on tempdb? : sql server database administration

0 Answers  

---

What is create command?

0 Answers  

---

What are the dis_advantages of stored procedures, triggers, indexes?

0 Answers  

---

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What is advantage data architect?

0 Answers  

---

What is the stuff and how does it differ from the replace function?

0 Answers  

---

What is normalization according to you and explain its different levels?

0 Answers  

---

What is the process of normalising?

0 Answers  

---

What is partition index in sql server?

0 Answers  

---

What is implicit mode in sql server?

0 Answers  

---