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 snapshot replication?

0 Answers  

---

Why truncate is ddl command?

0 Answers  

---

mention different types of relationships in the dbms?

0 Answers  

---

What is xml datatype?

0 Answers  

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

What is the difference between update lock and exclusive lock?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  

---

What is table-valued sub query?

0 Answers  

---

What is a transaction and why is it important?

0 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

What are “phantom rows”?

0 Answers  

---