haiao2000 (4/29/2013)

---

GilaMonster (4/29/2013)

---

Do Not delete the log file.

Add more space and/or remove files that aren't necessary (old backups, logs, etc)

What error do you get when you try to connect? Logging...

Ad-hoc SQL has exactly the same plan caching and reuse as stored procedures, the matching is just done on a...

Try a plan guide, you may be able to overrule the join hint with another, though you will have to work out what the optimal join is and keep testing...

http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

Was TempDB out of space as well? Was there a logon trigger?

Yes, it's an optimisation, SQL caches the definition and a single data page to reduce the work required to recreate it. The table variable's effectively gone, you cannot access it...

Do Not delete the log file.

Add more space and/or remove files that aren't necessary (old backups, logs, etc)

What error do you get when you try to connect? Logging in doesn't...

Take a read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

AWE does, max server memory is immediate.

You change that through SQL, either with SSMS right click the server, properties, memory or using sp_configure

Please note: 4 year old thread.

The presence or absence of a log backup will make absolutely no difference in this case as you're shrinking a data file, not a log file.

LOB data causes shrinks to...

S_Kumar_S (4/29/2013)

---

So I am left with option 2 only. Here also, the log size takes 2 hours to grow to 160 GB. So when log backups are happening every 20...

I suggest the following for that script:

Ctrl-A, Del.

Then read over this for an idea on how to manage your transaction logs properly.

Managing Transaction Logs[/url]

More TempDB space, more resources, longer duration. It still takes locks, just short-lived ones