Yes, it is necessary. Rebuild the system databases, start SQL, restore the backups of the system DBs.

Why?

Not sure where you saw that. Paul stated in the first section:

Index...

Can you post the graphical plans please?

You can also edit all the procs (slow, I know) to log to a table when they are executed.

PiMané (11/27/2012)

If a table as an index with Col1, Col2, Col3 and includes Col5, Col4, Col7 (by this order) this index is obsolete if we have another index with Col1,...

Could you perhaps be a little more specific about what you're trying to do?

Internal Revenue Service?

No, the problem is not because there are two statements. It's because if you run that more than once, the second, third, etc executions will fail because the column already...

It's not seconds (anymore). It's a meaningless, unitless number.

It was originally based off of seconds on a specific benchmark machine back when the QO was initially developed, back sometime in...

And from the other instance?

It's a view, not a table (stated as such in a different thread).

Naga, as Opc stated...

Is the amount of data in the two tables the same (not the amount returned, the amount in the tables)

Are the hardware specs the same?

Can you post the xml plan...

Write your queries to fetch just the data that you need. Fetching data to the front end that you don't need and discard is a waste of time, resources, network...

http://www.google.com/search?q=allocation+contention+TempDB