Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

---

Why do we use non clustered index?

0 Answers  

---

Explain Capacity planning to create a database? and how to monitor it?

0 Answers  

---

What does the on update no action do?

0 Answers  

---

---

What factors you will consider calculating the storage requirement for that view?

0 Answers  

---

What is difference between aggregate and analytic function?

0 Answers  

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

---

Is it possible to create trigger on views?

0 Answers  

---

What are points to remember while using the fillfactor argument?

0 Answers  

---