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...

kevaburg (12/6/2013)

---

Grant Fritchey (12/6/2013)

---

kevaburg (12/6/2013)

---

For this sort of thing I would recommend a server-side profiler trace. Don't use the Profiler itself if you intend to trace over an extended...

But you were right to point out that what I said was insufficiently clear. That can lead to all sorts of problems.

Oh well heck, everyone else has said it and now I feel left out.

Congrats Gail.

What was it you did again?

...

Kidding, kidding. Put that stick down... 😛

kevaburg (12/6/2013)

---

Grant Fritchey (12/2/2013)

---

When you run a full backup, it also backs up the transaction log. If your transaction log has 30gb of transactions that have not been backed up...

If you're on...