oops, maybe you meant these stats:

(521 row(s) affected)

Warning: Null value is eliminated by an aggregate or other SET operation.

Table 'tbCurvePoint'. Scan count 0, logical reads 0, physical reads 0, read-ahead...

I'll try chasing down some of the Bookmark Lookups and see if I can put a covering index in place to handle them. I was able to remove some...

this is going to be tought to read, but...

StmtText ...

I really appreciate the help...

ALTER view vwPositionByBizStrategy

as

select

min(S.BizSubBusinessUnitName) as BizSubBusinessUnitName,

min(BU.BizBusinessUnitName) as BizBusinessUnitName,

D.BizStrategyName,

I.SevernTicker,

min(I.SecurityName) as SecurityName,

min(I.CommonTicker) as CommonTicker,

min(IT.InstID) as InstID,

-- added fields...

actually, now that I'm looking closer, I'm seeing hundreds (thousands?) of locks, aquired and released on the same millisecond in time around the same time that a select to my...

it was the wins being > 100 like you suggested. in the select list and in the group by.

it was trying to shoehorn 101.4 into decimal(3,1)

you can get the...

also, I put the "WITH (NOLOCK)" hint on all the tables in the view. this is where you where I should be putting them, right?

Are you using the "with (NOLOCK)" optimizer hint on the tables within the query?

DIDN'T SEEM TO HELP.

What is the reason for the normally poor performance (1.5...

I ran sp_updatestats and saw no improvement. There is negligible fragmentation on the tables and nonclustered indexes.

you hit the nail on the head. I can see why that would be an overflow. tx

that's the rub! I'm using "background" (I've been calling it "change tracking" in these threads.)

Background of course!

I appreciate the help Gagandeep, and that *would* be exactly what I need, but as I try to implement it, it doesn't seem to be doing what I'd like. ...

I was pretty sure that was the case. Thanks for the confirmation. Unlucky!

that article is bookmark worthy. thanks Kalpesh.