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

Explain different types of lock modes in sql server 2000?

0 Answers  

---

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

---

What is a trigger in sql server?

0 Answers  

---

Explain different types of Normalization.

1 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

---

What is service broker?

0 Answers  

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  

---

Distinguish between commit and rollback?

0 Answers  

---

can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

What is the language structure to add a record to a table?

0 Answers  

---