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 an indice?

0 Answers  

---

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

---

Explain different types of collation sensitivity?

0 Answers  

---

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

---

in how many ways we can use count()

2 Answers  

---

What is the stored procedure?

0 Answers  

---

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

---

How to list all tables having unique constraints in any of the columns in a database.

1 Answers  

---

what is meant by deafult in sql server?

2 Answers  

---

what is the query and condition to delete datas in sql server.

2 Answers  

---

What is collation sensitivity?

0 Answers  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---