Correct that we are DBA's,...

As I thought about goals / resolutions this year, I had to get realistic about how much I want to accomplish as a SQL professional vs. how much I want...

Thank you for sharing, I'll be watching out for this...

Still my favorite!

Thanks Craig, that actually helps validate the direction I'm going. I appreciate your thorough feedback.

One more question on log contention: I basically have an OLTP database doing lots of little...

Here's what I've decided to go with - a nice standard "medium" type solution (in Denny Cherry terms):

- 4 new drives 600GB 15k rpm in a RAID 10 for Tran...

Thanks for the update. Right, 1222, not 1322.

What I found is that a job which use to run in a few seconds is now taking a few minutes. The...

Did you ever get a bead on this? I'm also seeing a rash of 1322's, but only on one server...

Loved this analogy...

Ron Porter (11/2/2010)

---

I think that the Internet is just one more step along the 'just in time' path...There are risks associated with not keeping our own gardens...

Okay, I now have a job running every 5 minutes on the "DB2" server that forwards Job errors to the central "DB1" server. The job calls "usp_ForwardSqlJobErrors" which uses a...

Yep, using Notifications at the DB1 site, they work great. Not an option at DB2.

Not to be too lazy 😉 but it seems like the SQL Agent Event Forwarding...

I hadn't really considered polling. I had been attacking the problem from an "event forwarding" perspective. With a polling solution, I guess I would need to keep some kind of...

Larry rocks... I love the grass.

Have you tried forcing it to used the clustered index with a query hint?

I know that index is bigger, and SQL is probably not choosing it for a good...

Still funny... and this is like my fifth reading over the past few weeks 😛