Normal, expected, documented behaviour. If SQL's using too much memory, you need to change the max server memory setting to tell it how much it may use.

Chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Work through the procedures, see if you can rewrite them not to use cursors and temp tables.

Btw, watch those nolocks.

See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

Maybe. Means that if the latest full backup is corrupt or...

What are you using a table variable for? There's no need for table variable, temp table or cursor that I can see here.

It will use the same disk space, disable's...

You need to close the query window from which you ran the truncate (or change the database context to some other database). It's not that truncate is holding any exclusive...

Doesn't matter whether it's one drive or multiple in a RAID array, my answers stand. You may or may not get a performance improvement from splitting files onto multiple independent...

Sean Lange (5/20/2013)

---

Lynn Pettis (5/20/2013)

---

Sean Lange (5/20/2013)

---

I don't think you need dynamic sql for this to work. You just need to get the right syntax. If you had posted the...

That doesn't actually start a transaction, and you can prove it by running that in one management studio window and running DBCC OPENTRAN in another.

The transaction will only start...

Deny them insert, update and delete on all tables in the database. Only way since all data modifications run in transactions

Bear in mind that if you disable the indexes you need to rebuild them afterwards. Unless you're doing a huge amount of inserts/updates, the cost of the rebuild (and logging...

Please note: 3 year old thread that was not about mirroring.

Maybe

No.

Please note: 7 year old thread.