rchantler (10/27/2008)

---

The optimized view uses specific join algorithms, e.g. loop joins, hash join and merge joins instead of the more generic inner and outer joins used in the original view...

Chris Morton (10/22/2008)

---

How Do I put the result of

EXECUTE

( 'SELECT count(' + @columnname...

Duplicate post. Please direct replies to http://www.sqlservercentral.com/Forums/Topic592120-373-1.aspx

Jonathan Kehayias (10/27/2008)

---

I'll have to go back and look at why I would have been using that flag, and I will definately update the references that I provide...

Does it speed up the insert? Have you tested with and without the index recreation and proven that it's faster...

Now things become a little clearer. Is the query you posted taking 21 seconds or is the entire stored procedure (with the inserts and all the index creations) taking 21...

It could be due to a database/log restore. (Is this a logshipping destination?). It could be from certain configuration changes (sp_configure). It could be from someone running DBCC FREEPROCCACHE. It...

Jonathan Kehayias (10/27/2008)

---

Trace Flag 3605 with -1 will write the output of the other flags being enabled to the SQL Server Error Log for every SPID on the server. ...

The first thing you should do is make sure that all tables have primary keys and are properly normalised.

Run profiler for a while during your busy times. Record the rpc:completed...

Maybe

Shall I...

The entire result please....

You should never run repair on a regular basis. It should only be run when there is corruption, and there's no other way to fix it. It's a last resort,...

What are the view definitions? What indexes are...

Great. Please can you post table definition and index definitions.

How many rows are in the tables? How many does the query return? How long does the query run?

The plan looks...

Run the query with the execution plan option on.

Right click the generated plan and select save. Save it as a .SQLPlan file (You are using SQL 2005? I assume so...