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 are the features of Embedded SQL

0 Answers   HCL,

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---

In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,

---

---

Can you explain what are commit and rollback in sql?

0 Answers  

---

What is dynamic cursor in SQL SERVER?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

What is function of ROLLUP ?

0 Answers   HCL,

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  

---

What is an index in a database?

0 Answers  

---