Interested to Buy Any Domain ? << Click Here >> for more details...
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>]]
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Tell me what are the advantages of using stored procedures?
Can you insert NULL in unique column?
Explain steps of normalization?
What is the difference between push and pull subscription? : sql server replication
Where are SQL server users names and passwords are stored in sql server?
What are entities and relationships?
Tell me what is a linked server?
What is dirty read?
What is an execution plan?
What is advantage data architect?
How to find Duplicate Records In table?
What are the disadvantages of primary key and foreign key in SQL?
Explain transaction server isolation?
whats the maximum size of view state??
