The dreaded "IS NULL OR" construct. DON'T DO THIS AS WRITTEN!!

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Given the design you describe cursors are probably the way to go and nothing wrong with that (assuming what is being done per object is actually set-based/efficient). I question the...

ThomasRushton (5/9/2016)

---

Wayne West (5/6/2016)

---

xsevensinzx (5/6/2016)

---

Being no one has mentioned it yet, if you do transfer, note the bandwidth usage if applicable. We had multiple lines and we dedicated a full...

And you didn't provide the information I asked initially if that was the case: WHAT CHANGED?!?! 🙂

Your production database presumably has actual production work being done, meaning some locks are probably being taken on the table. So your query could simply be waiting for said locks...

1) Buy bigger hardware? Or configure a bigger VM? What are the specs now?

2) You did not answer question 2 from my initial response.

GilaMonster (5/5/2016)

---

I'd recommend extended events on 2012. Add in the QueryHash column and the aggregation is trivial to do in T-SQL, no need for string comparisons for ad-hoc queries any...

GilaMonster (5/5/2016)

---

Identify the queries using the most CPU and tune them. This may not be the most expensive individual queries, probably isn't. The query that runs once an hour for...

1) If you need help "ASAP" to get a production server running acceptably the best way BY FAR to accomplish that is with a consultant. There are a number on...

First thing to do is make sure you have an index on the key field(s) being used to delete from the big table. If not you are totally hosed by...

1) Cursors (actually almost ANY row-by-agonizing-row or iterative processing) in SQL Server is horribly inefficient.

2) You need to provide us with table definitions and actual data for them (in the...

mmcbride 2735 (5/4/2016)

---

Hi Sorry for lack off information.

All my application databases are on sql server 2012 but need to move them to the new vm I have created on the...

MadAdmin (5/3/2016)

---

TheSQLGuru (5/3/2016)

---

Gail is spot on as usual.

I have been consulting on SQL Server since the mid-1990s and I can count on two hands the number of times I have...

Backup and restore works fine.

Detach and reattach works fine (beware the stats updates though - make sure you tell the script to not do those).

If this is a migration...

1) What build of sql server are you on?

2) How, EXACTLY, are you determining how much memory the SQL Server windows service is using?

3) Have you run dbcc memorystatus and...