Yes, already recommended fully parameterized queries. Thank you!

So there is nothing i can do to force the query to reuse some execution plan?

I mention that I cannot change the query...

I got the answer already:

http://www.brentozar.com/archive/2014/12/whitespace-comments-forced-parameterization-sql-server/#comment-2226931

Hi!

@ 1) I am not sure what those 58GB are reserved for; i thought they were for query execution. So ... please excuse a dummy question: could you please clear...

Hello!

Did you find a solution for this? We have a similar problem on SQL 2012, SP2. It even determines the server to shut down.

Thank you!

Hello

In the video it says duration is the total amount of time spent by an event, from beginning to end.

My question is what is beginning and what is end? For...

Hey!

This does not work for CSV. Do you know a work around for export to CSV? I need to set the DataElementOutput dynamically, based on some parameters.

Thank you,

Iana

Hello again,

Problem partially solved. Here is what we did:

- determined which was the blocking recovering database

- stopped SQL Services

...

Hello,

Thank you for your replies.

The disks are accessible, the db files are accesible. I even copied some of them (while the server was stoped) and attached them to another SLQ...

Hello

Unfortunatelly I am having a simillar issue and waiting for the database to recover seems not to work for me. The database seems to be stuck in RECOVERING state.

Moreover, if...

how? how did you solve it? please help!