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 will add additional conditions in sql?

1111

---

How many types of subqueries are there in sql server?

993

---

How many tables can be joined in SQL Server?

1069

---

How exceptions can be handled in sql server programming?

1019

---

what is checksum in sql server.........???

1691

---

What is bulkcopy in sql?

951

---

How do you Implement SSIS Packages in your Project?

1934

---

What are the disadvantages of using the stored procedures?

1110

---

What happens on checkpoint?

1029

---

How to list all objects in a given schema?

1064

---

What are Row versions of DataRow?

1035

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

969

---

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

154

---

Tell me when is the update_statistics command used?

1119

---

Explain what are magic tables in sql server?

1001

---