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 purpose of normalization?

0 Answers  

---

What are the new security features added in sql server 2012? : sql server security

0 Answers  

---

Tell me about builtinadministrator?

0 Answers  

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

---

What is Pointer ?

3 Answers   Cap Gemini, CarrizalSoft Technologies,

---

What is the meaning of sql server?

0 Answers  

---

What happens if null values are involved in boolean operations?

0 Answers  

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

---

Explain how to maintain a fill factor in existing indexes?

0 Answers  

---

Does partitioning help performance?

0 Answers  

---