Answer / sam

statistics in SQL Server refers specifically to information
that the server collects about the distribution of data in
columns and indexes. This data in turn is used by the query
optimizer to determine the plan of attack for returning
results when you run a query. While in the majority of
cases SQL Server takes care of this statistical
recordkeeping for you automatically, it's useful to have
some understanding of what's going on, and to know when you
might need to intervene.

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

---

Why normalization is used?

0 Answers  

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

How do you know if sql server is running on your local system?

0 Answers  

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers  

---

What is the maximum size of sql server database?

0 Answers  

---

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---

What is the purpose of the model database?

0 Answers  

---

What is a DBMS, query, SQL?

0 Answers   Maveric,

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

What is an indice?

0 Answers  

---