+1

I liked the first edition 🙂

can't wait to devour this one :w00t:

actually .... nothing !

it only exports sqlplans and consumption data ( as stated in the query to be run by the script ).

( I must have misinterpreted your previous replies...

If you're in for some Powershell, maybe the attached ps1 script can help out :w00t:

It will prompt for a sqlserver name ( servername\instance or just servername if you have a...

If you have the full query, just attach it to your forum reply.

You may also want to take a look at dmv sys.dm_exec_sql_text(sql_handle | plan_handle)

and/or

sys.dm_exec_text_query_plan

(

...

Because estimates and actuals are that much dissimilar, maybe have a look at Daves article "When estimation goes wrong".

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2012/11/26/when-row-estimation-goes-wrong.aspx

I think trying out his workaround is worth the test.

Nice article, Jeff.

Ye good old fashioned "take controle and beat the system hands down" still does it. 😀

Great article, Jonathan.

For alerting and recording all auto grow of your databases, that is the way to go.

Just for the record, if readers are saving default trace files: they also...

you could also try to fetch SQLPlan data out of your sql engine, or post the estimated execution plan.

Using SqlServer Management Studio, you could highlight the actual code withing the...

now go check your indexes, triggers and specific grants that existed for your old (and dropped) table !

I didn't read over the full thread.

Did you check your backup file folder isn't being compressed at windows level ??

Thank you for the feedback.

Now I get it too :w00t:

I only see that column being non-zero for sproc

msdbsp_delete_job_references

At this moment I cannot tell you what that actually means or why it defers from the others.

did you have a look...

calling the sproc with different settings on you connection will be enough for sqlserver to generate another plan. ( ansi settings )

from Books online : http://technet.microsoft.com/en-us/library/ms178615.aspx

STANDBY =standby_file_name

Specifies a standby file that allows the recovery effects to be undone. The STANDBY option is allowed for offline restore (including...