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.

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

what are isolation levels? : Sql server database administration

0 Answers  

---

What is the difference between UNION and UNIONALL?

5 Answers   CarrizalSoft Technologies, CTS,

---

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

---

---

Explain about SQL server 2005?

0 Answers  

---

What is data file in computer?

0 Answers  

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---

What is factless fact table? : sql server analysis services, ssas

0 Answers  

---

Explain go command in sql server?

0 Answers  

---

what happens on checkpoint? : Sql server database administration

0 Answers  

---

Explain what are commit and rollback in sql?

0 Answers  

---