Answer Posted / vampire007

We use GroupBy clause to analyze data in table,by means of
various sql server aggregate functions like SUM(), AVERAGE
() etc., according to some domain.

For eg., If we want to know the sales done by a every
employee, then we would use somewhat this kind of query:

/**
select employeeid, count(*)
from orders
groupby employeeid
order by employeeid
**/

How raid can influence database performance?

1034

---

What is sql server agent and what are the two modes of authentication in sql server?

1056

---

How can I create a new template for import ? : sql server management studio

1073

---

What are the approximate numeric data types?

936

---

Why I have to use stored procedures?

1050

---

What stored by the msdb? : sql server database administration

1004

---

What is report rendering ?

157

---

What is the use of @@spid?

1001

---

What is database dimension? : sql server analysis services, ssas

1080

---

Which is better statement or preparedstatement?

930

---

How to configure and test odbc dsn settings?

1160

---

What is cursors?

1187

---

What is the use of floor function in sql server?

1081

---

Explain use of expression builder.

1025

---

What is the difference between a primary key and a unique key? Are they the same?

1077

---