Answer Posted / 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 database isolation in sql server? : sql server database administration

1151

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

---

What are out-of-range errors with date and time literals?

1092

---

How do you debug a procedure in sql server?

992

---

What is data source object?

1064

---

What is buffer cash and log cache in sql server?

1183

---

How to execute function in stored procedure sql server?

1228

---

How do I trace a query in sql server?

997

---

What is normalization? Describe its different types.

1151

---

Define cross join in sql server joins?

1078

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1111

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1165

---

What do you know about normalization and de- normalization?

968

---

How to search for a string in all stored procedure in sql server?

1054

---

How to achieve Paging of records in SQL SERVER?

1139

---