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

How do I start and stop sql server?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,

---

How to test a dml trigger in ms sql server?

0 Answers  

---

List the different normalization forms?

0 Answers  

---

---

How to set database to be single_user in ms sql server?

0 Answers  

---

How to create Clustered Primary Key to table?

2 Answers  

---

how can you move the master database

1 Answers   IBM,

---

What are constraints?

0 Answers  

---

How is sql used in sql server?

0 Answers  

---

Explain what is the use of custom fields in report?

0 Answers  

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---