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 is normalization? Explain its different types?

0 Answers   GE, Maveric,

---

How is sql used in sql server?

0 Answers  

---

What is raid and what are different types of raid levels?

0 Answers  

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers  

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

---

Will the writetext statement activate a trigger?

0 Answers  

---

What are different replication agents and what's their purpose? : sql server replication

0 Answers  

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

How to perform key word search in tables?

0 Answers  

---

How many joins in sql server?

0 Answers  

---

How to create a store procedure with encryption?

0 Answers  

---

Can sql servers linked to other servers like oracle?

0 Answers  

---