Answer Posted / 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

What is sql server 2000 work load governor?

1035

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1045

---

Explain view in sql server?

1043

---

What is default constraint?

976

---

how many no of arguments can be passed in procedures and functions

5528

---

What are Row versions of DataRow?

1006

---

How to set a database state to offline in ms sql server?

1020

---

Can we call future method from trigger?

914

---

What is check constraint in sql server?

980

---

What is temporal data type?

902

---

What are various ways to enhance the ssrs report?

967

---

How to use old values to define new values in update statements in ms sql server?

1242

---

How to count duplicated values in a column in ms sql server?

1055

---

What is the difference between lock, block and deadlock? : sql server database administration

1024

---

How many non clustered indexes there can be on table ?

892

---