It's probably your code, or your statistics, or the lack of an index. Those are much more likely than fundamental memory issues, but they can all lead to memory issues....

Without seeing the execution plan I couldn't say for sure, but I'll bet the plan for the statement without the CASE is more accurate to your indexes and statistics while...

What does the error log of the system being shut down say? Are there any entries in the Windows logs suggesting possible problems?

Unless you've set up extended events (or a server-side trace) to capture that type of information, there's no way to get it just by querying SQL Server. It's not stored...

Be careful with statements like that. Parameter sniffing is an automatic process...

Different servers makes it more difficult. In order to use a trigger you'd have to use a linked server. It sounds less viable now than it did. The different data...

Sounds like a situation that will be answered by a trigger. You can do a cross database query pretty easily if they're on the same server.

Primarily as a measure of load you can look at page faults/sec. That will tell you how many times SQL Server had to go looking for pages within memory. You...

Shortest answer I can give you, start with a place that reasonably well known and legit. You're just getting started as an author. That means you're going to have to...

Another set of mechanisms for getting versioned data (the latest) are illustrated in this article[/url] I wrote for Simple-Talk.

This is usually caused from one of two sources. You've had data changes recently that have resulted in the distribution of your data to change, updating the statistics, and the...

When I'm deploying database changes to an Enterprise system, I'll use snapshots to make rollbacks very fast and easy should something go wrong during the deployments. I won't keep those...

It sounds like you are running into some sort of resource issue according to the error message:

Insufficient system resources exist to complete the requested service

Without more information, I'm not sure...

The same process will write dirty pages to disk and free clean pages when they pass the least recently used threshold.

Ed Wagner (12/6/2013)

Yeah...I...