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>]]

Explain following error properties?

1023

---

What is openxml in sql server?

1179

---

What is the purpose of linked server configuration in sql server?

1050

---

How do we know if any query is retrieving a large amount of data or very little data?

977

---

Explain Geography datatype in SQL Server

1136

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1015

---

In what sequence sql statement is processed?

1016

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

987

---

Explain the different types of backups available in sql server? : sql server database administration

930

---

What is the sql profiler?

947

---

What is temporary stored procedure?

949

---

Explain the difference between control flow and data flow?

1005

---

What are the different types of upgrades that can be performed in sql server?

1177

---

Define the one-to-one relationship while designing tables.

903

---

Explain magic tables in sql server?

1062

---