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 can I check if a view exists in a sql server database?

1014

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

992

---

Explain the Ways to improve the performance of a sql azure database?

84

---

If no size is defined while creating the database, what size will the database have?

968

---

how to define testing of network layers? : Sql server database administration

953

---

Explain datetimeoffset data type in sal server 2008?

892

---

what is a sub-report?

140

---

Does the order of columns in update statements matter?

906

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1120

---

How to disable stored procedure sql server?

1587

---

Can we join two tables without primary key?

1021

---

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

939

---

What do mean by xml datatype?

1068

---

What does the on update no action do?

1002

---

Explain an automatic checkpoint

961

---