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 display code or Text of Stored Procedure using Sql query in Sql Server ?

0 Answers   Wipro,

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

---

What are the types of dml?

0 Answers  

---

What is the importance of concurrency control?

0 Answers  

---

---

What happens if ntwdblib.dll is missing on your machine?

0 Answers  

---

Write a program using SQL queries to find a unique entry in a table.

0 Answers   Tech Mahindra,

---

can you any body tell me the how to decrease the logfile

4 Answers  

---

Why de-normalization required?

0 Answers  

---

How many types of Cursor in SQL SERVER?

1 Answers  

---

What happens on checkpoint?

0 Answers  

---

What is standby servers? Explain types of standby servers.

0 Answers  

---