In addition to Matt's note, a WHERE clause definitely helps. At the very least it's less log records to write and then backup, store on disk, etc.

However indexing matters, and...

I too cannot follow what you are looking for. You either need a CASE in the SELECT list, or something in the WHERE clauses, but it's not clear.

When you show...

I'm a bigger fan of #2. You can join to the main table, but I've seen performance problems with this when you have people doing a lot of auditing....

If you are installing SQL Server 2008 on the production server, I'd recommend you install Service Pack 1 for SQL Server 2008 and stop. The cumulative updates are not regression...

I like baseball 🙂

Open to suggestions for better names. I think I set these up during the playoffs in 2005 or 2006

No idea, I'm deleting them as I find them, or they get reported.

Mostly I think it's a few people behaving badly.

Feel free to report these with the "report" button. No comment needed, I'll delete them.

I was thinking the multiple CTEs. The idea being to abstract out those subqueries and make them easier to code without having to create a view. I think it works...

Mirrored on this same server? I'm worried that the firewall or network is limiting the comm back from the DR server to the production server. That's why I'd test a...

I saw a produce recently that would move SSRS into Silverlight, so I'm sure that it is used as web reporting. It's that I don't know anyone touting it as...

Are they saying they have a hard coded connection string? I'd ream the vendor if this is the case.

The alias could be anything. You give it a name and then...

I don't see a logical reason in there either. Have you tried grabbing @@TRANCOUNT in between all the try..catches to see if it's actually being increased and you have an...

I would lean towards a bug, or a network issue. Can you try this? Create a small db, say 1MB, mirror it to the DR server. Create a table in...

I'm curious why SIMPLE mode. It's usually a bad idea.

As far as specs, it's hard to know unless you know what SQL is being run. One person on the box,...

I agree with Lynn. A SELECT might blog an insert/update/delete from committing, but that doesn't mean more log records. The SELECT is not logged.

I can start a tran, do...