what is normalization? : Sql server database administration

0 Answers  

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

What is the difference between set and select?

0 Answers  

---

How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,

---

What is the difference between online clustering and Offline clustering?

0 Answers   IBM,

---

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

Can we call future method from trigger?

0 Answers  

---

How to list all objects in a given schema?

0 Answers  

---

How do you size a resultset?

0 Answers  

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

What is sql collation?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---