Explain having clause and where clause?

0 Answers  

---

Where do you find the default Index fill factor and how to change it?

0 Answers  

---

Explain about Joins?

0 Answers   Infosys,

---

What is oltp (online transaction processing)?

0 Answers  

---

What is function of CUBE ?

0 Answers   HCL,

---

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

Why we use trigger in sql server with example?

0 Answers  

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  

---

What is 'Join' and explain its various types.

0 Answers   Genpact,

---

What is Trigger?

3 Answers   Misys,

---

can an order by clause be used in a creation of a view?

0 Answers  

---