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

As long as you stay on the same SQLInstance, it should be OK.

Just:

1) create another DB ( enable ownership chaining )

2) create the table you need

3) grant the account being...

way to late ( due to summer holidays ) but here are the results on my dev server ...

I loaded 1000000 rows is MytestTable;

use SSC_Test

/*

DECLARE MytestTable TABLE ( col1 INT,...

Great thinking pattern !

Marvelous results !