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

Can we insert data into view sql server?

981

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

973

---

What are distributed partitioned views?

1134

---

What is join query?

938

---

How to add the custom code in Report?

129

---

What is the difference between coalesce() & isnull()?

1187

---

What is policy based management (pbm)? : sql server database administration

1029

---

What is tcl in sql server?

1168

---

Can you pass expressions to function parameters?

1150

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

1000

---

What security features are available for stored procedure?

1075

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2115

---

Explain tables in SQL Azure?

122

---

What is difference between clustered and non clustered index?

1032

---

Explain the microsoft sql server delete command? : SQL Server Architecture

1146

---