Hi Robert, sure you can, I have updated version of it, not sure why the old one is posted. I'll attach it soon

use a server side trace and save to file.

There is a job that executes sys.sp_dbmmonitorupdate every minute.

After I read this statement i realized that another DBA decided to...

Kristen-173977 (9/29/2015)

So if you don't have a performance problem yet then you could easily in the future, at which time the fix would be very expensive to retro fit. ...

Alan.B (9/29/2015)

Wouldn't it be better to have at least separate stored procedure to use in all those different places but only returning columns that they actually need or maybe replace...

I think what you are trying to say is doing maintenance just BEFORE the...

The statistics are about the same for both cases. I was actually testing it quite deeply last week as i wasn't sure if CAST(logdate AS date) = '20150911' is a...

Yes but if i won't specify a thing it will be FORWARD_ONLY DYNAMIC?

I was reading https://msdn.microsoft.com/en-us/library/ms180169%28v=sql.110%29.aspx

and was trying to find out what is the default behavior but it only says that:

If FORWARD_ONLY is specified without the STATIC, KEYSET, or DYNAMIC keywords,...

Thays what I was expecting. Thanks for the explanation Luis

Thanks Louis, that solves the problem. Just got a bit confused whit this behavior.

Luis Cazares (9/4/2015)

No, neither the ORDER BY for window functions.

But the Quirky Update is supposed to be even faster. For more information:...

was this ROWS/RANGE "hint" available in 2008/R2?

also the default behaviour of over without ROWS BETWEEN UNBOUNDED PRECEDING caused a large number of reads on Worktable, after adding it it went...

Just to let you know the execution time of the stored procedure that was using this part of code reduced from over 13 minutes to 3 seconds