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

Explain boyce and codd normal form(bcnf)?

922

---

Does full backup break log chain?

947

---

State the difference between union and union all?

918

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

954

---

What is a result set object returned by odbc_exec()?

1003

---

Explain what are the authentication modes in sql server?

995

---

what are the reporting service components in SSRS?

163

---

What is instead of trigger sql server?

983

---

What is the osql utility?

941

---

What is the difference between a "where" clause and a "having" clause?

1148

---

Can we write a distributed query and get some data which is located on other server and oracle database?

1208

---

How to convert binary strings into integers in ms sql server?

1006

---

How do I completely remove sql server instance?

1077

---

How to disable a login name in ms sql server?

1110

---

What are the different types of locks in the database?

910

---