You can still look for them and bring them to the vendor's attention.  But it may not be anything to do with the quality of their code - it may...

The default trace will show you when tempdb grew, but not why.  Analysing tempdb growth is difficult, because there are so many moving parts.  Are you using Snapshot Isolation?  Does your code...

It's all in the link I posted, as far as I can see.  Please ask if there's anything in particular you don't understand, or if anything appears to be missing.

John

Oh yes, that's...

Sam

Space from deleted data is not automatically released to the operating system.  You have to shrink the data files to get the space back.

Please post the code that your App...

• This reply was modified 5 years, 10 months ago by John Mitchell-245523.

Yes, with the Actual execution plan, you get estimated and actual values.  By comparing them you can get some idea of how accurate your statistics are.

John

1. I don't advise it.  Those are Estimated costs, and the estimates are only as good as your statistics, and things get even worse when a linked server is involved. ...

As I explained earlier, if you do that connections that started and finished between savings won't be captured.  That's why it's better to use Audit, XE, trace, eventlog or whatever...

I won't say that you absolutely can't, but it would be a lot easier to pull it all into a table daily (or whatever frequency works best for you) for...

I agree about preferring sp_execute_sql, but I think it's only one particular feature of the command that's deprecated, not the command itself.

John

Sounds about right.  But then you'll be exporting to the exact same file from your job, and if you still have that file open, it'll fail.  If you don't still...

I don't know, because I can't see what you can see.  Is changing the name of the file you're exporting to an option?

John

There is nothing else opened where?  If the workbook is on a file share, it could be in use by anyone anywhere (depending on how tightly you define your share...

It looks as if you're trying to open an Excel workbook but another user or process already has it open.

John

I'd also get out of the habit of having discrete logins even if they're Active Directory logins.  Use Active Directory Groups instead.  Of course, the exception (there's almost always...