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 usage of sign function?

0 Answers  

---

How to move database physical files in ms sql server?

0 Answers  

---

Explain the various types of concurrency problem?

0 Answers  

---

Do you know what is sql injection?

0 Answers  

---

How to get all stored procedures in sql server?

0 Answers  

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

Which tcp/ip port does the sql server run on? How can it be changed?

0 Answers  

---

what is a correlated sub-query? : Sql server database administration

0 Answers  

---

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---

Explain the commands in sql server?

0 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

What is difference between delete and truncate commands?

0 Answers  

---