Answer / rajesh ranjan

Hi

This command is basically used when a large processing of
data has occurred. If a large amount of deletions any
modification or Bulk Copy into the tables has occurred, it
has to update the indexes to take these changes into
account. UPDATE_STATISTICS updates the indexes on these
tables accordingly.

Answer / anand

The UPDATE STATISTICS statement defines the storage
requirements of tables and indexes as well as the value
distribution of columns, and stores this information in the
database catalog.

Syntax
<update statistics statement> ::=
UPDATE STAT[ISTICS] COLUMN <table name>.<column name>
[ESTIMATE [<sample definition>]]
| UPDATE STAT[ISTICS] COLUMN (<column name>,...) FOR <table
name> [ESTIMATE [<sample definition>]]
| UPDATE STAT[ISTICS] COLUMN (*) FOR <table name> [ESTIMATE
[<sample definition>]]
| UPDATE STAT[ISTICS] <table name> [ESTIMATE [<sample
definition>]]
| UPDATE STAT[ISTICS] [<owner>.][<identifier>]* [ESTIMATE
[<sample definition>]]

What are the common performance issues in sql server?

0 Answers  

---

List the different types of joins?

0 Answers  

---

Difference between Cluster and Non-cluster index?

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

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

---

What is the difference between count and distinct count?

0 Answers  

---

Can I save my report as html, excel or word? : sql server management studio

0 Answers  

---

Write a sql query to get zero records from a table having n number of records?

0 Answers   TCS,

---

Explain ms sql server reporting services vs crystal reports?

0 Answers  

---

Explain the dirty pages?

0 Answers  

---

What is left outer join in sql server joins?

0 Answers  

---

What is a NOLOCK?

3 Answers   NA,

---