Answer Posted / nscom

There are three scenarios where you need to fire the update
statistics
1. Query execution times are slow.
2. Insert Operations Occur on Ascending or Descending Key
Columns
3. After Maintenance Operations - Operations that change the
*distribution of data" such as truncating a table or
performing a bulk insert of a large percentage of the rows.
More information is here
http://msdn.microsoft.com/en-us/library/ms190397.aspx#UpdateStatistics

how to use DTS package in 2000,2005,2008 in sql server

1800

---

How to resolve the orphan use problem? : sql server security

971

---

What are the grouping functions?

900

---

Explain about integration services of Microsoft SQL server?

996

---

What is dml command?

904

---

How you can get the list of largest tables in a database?

958

---

Introduction of rollup clause using sum and group by clause?

912

---

What is the difference between for trigger and after trigger?

1048

---

What is a data source or ds? : sql server analysis services, ssas

967

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

999

---

Can we use custom code in ssrs?

1074

---

What is tcl in sql server?

1088

---

What is NOT NULL Constraint in sql server 2012?

949

---

How you trouble shoot when any job fails

1908

---

How to find the service pack installed? : sql server database administration

987

---