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 difference between nchar and char in Sql server ?

3 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

What is the concept of optimization?

0 Answers  

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

Explain the steps needed to create a scheduled job?

0 Answers  

---

What are the features of Embedded SQL

0 Answers   HCL,

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What is primary key index?

0 Answers  

---

Tell me when is the update_statistics command used?

0 Answers  

---

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,

---

what is a join and explain different types of joins? : Sql server database administration

0 Answers  

---

Is null vs coalesce?

0 Answers  

---