Here is further information :

I'm executing this query on both instances :

SET STATISTICS IO ON

GO

SET STATISTICS TIME ON

GO

Select fieldID, f.fieldName, FieldValue from field f

inner join dbo.getOppTableDataPivoted(3, 2) as t...

Both on the physical server.

No hyperthreading on the boxes

Both instances are at 9.0.3310 hotfix.

I agree that there must be a difference somewhere. The things is that I've been trying to find it that last 3/4 days and no...

Hi all,

I have give a lookup for a query and execution plnas are the same on both instances.

Concerning the parameters for the sql server instance both are the same. Parellelims...

I have have restored the same database backup on both instances so both databases have same indexes, same statistics, same amount of data and same number of users (Actually I'm...