A server-side trace is the best mechanism you have for doing this. They are not very resource intensive at all. In fact, it has a very light foot print as...

I get why compression could be said to reduce the DBAs workload. I'm just trying to figure out how encryption does that.

srinath.vanama (8/9/2011)

---

IN SQL Server 2008.

1) Backup encryption is possible.

2) Data compression and Resource governor.

3) Installation improvements. Disk images and service pack uninstall options.

4) TDE(transparent Data Encryption) Ability to encrypt entire...

It sounds like they were trying to get you talk about blocking which is caused when a resource is locked by one user, preventing the next user from accessing it.

Or,...

Without seeing the query and the execution plan, it's hard to tell you why it's taking a long time.

One point worth noting, when you tell it to return the TOP...

Out of time for what? Is this about you learning or about an emergency at work, or are we filling in for an interview?

For a great start on DMVs, I'd...

How to reduce the workload? Shoot the users? No, probably not.

You actually can't "reduce" the workload. What you can do is make the workload more efficient through design, construction &...

Anytime we're in Bradford, I have a pub selected. The only bad thing...

I suspect some of the databases probably have different drive or file configurations. You can't just replace these. You'll need to use a MOVE operation.

Have you tried to start the service? You can do that through the Management Studio interface or by opening the SQL Server Configuration Manager. You can even use netstart commands...

this implies that your backup process is managed somewhere else. Where is that? Remember, we're not there and can't see what you see. What service is sending out the email?

SQLRNNR (8/8/2011)

---

Grant Fritchey (8/8/2011)

---

SQLRNNR (8/8/2011)

---

Grant Fritchey (8/8/2011)

---

I've been failing at Google-Fu today. I'm trying to track down the name of that pet store (or at least a good copy of...

SQLRNNR (8/8/2011)

---

Grant Fritchey (8/8/2011)

---

I've been failing at Google-Fu today. I'm trying to track down the name of that pet store (or at least a good copy of the story about...

I've been failing at Google-Fu today. I'm trying to track down the name of that pet store (or at least a good copy of the story about it, name or...

SQLRNNR (8/8/2011)

---

Grant Fritchey (8/8/2011)

---

SQLRNNR (8/8/2011)

---

Grant didn't like it at all, but I also believe his configuration was a bit different...