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

What is SQL Profiler and the use of it?

2 Answers   247Customer,

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

What are the different acid properties?

0 Answers  

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

---

---

What are types of subqueries?

0 Answers  

---

Can primary key be a foreign key?

0 Answers  

---

What are the new features in SQL Server 2005?

3 Answers   Emphasis,

---

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

0 Answers  

---

List down some advantages of sql stored procedure?

0 Answers  

---

How to skip remaining statements in a loop block using continue statements?

0 Answers  

---

What is dbcc command in sql server?

0 Answers  

---