craig

thats the whole point you have to make a selection in the text editor

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...