From a performance perspective, isn't that worse than the hint?

I would think that the query with the additional hint added wouldn't have to be recompiled every time.

I narrowed it down to the problem query. It wasn't using the clustered index within the stored procedure. Whenever I ran the exact same query in query analyzer, it always...

Production Server:

3ghz / 3GB ram / SCSI RAID 5

Dev Server:

1 Ghz/ 512MB ram / SCSI no raid

I had already compared the execution plans and they were almost the same. The...

OK, cannot find any contention issues. The process basically takes denormalized data from a source table, parses and does some calculations and then inserts the normalized record into a fact...

Hi Adam,

Trying to see if we are getting row locking or some other contention between the loading queries and other system queries.

Used sp_who2 already, but it doesn't seem to show...