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 you create type- insensitive operator?

0 Answers   EXL,

---

How many databases instances are there in sql server 2000?

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

What happens on checkpoint?

0 Answers  

---

Explain logical operators in sql server?

0 Answers  

---

How do I view a stored procedure in sql server query?

0 Answers  

---

How is sql used in sql server?

0 Answers  

---

How to return the top 5 rows from a select query in ms sql server?

0 Answers  

---

What does COMMIT command do?

0 Answers   Amdocs,

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

Explain different types of Normalization.

1 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

Which are the important points to note when multilanguage data is stored in a table?

0 Answers  

---