Do you need left joins to all those tables? Or is it just one that might be missing rows?

Also, pls post the DDL as mentioned by John.

William,

Thanks for the link and that is definitely cool. I knew they were working on something, including the Volt, but hadn't seen this one.

I would love to see all the...

After having the car for 10 months, I think it compares well with a midsize car. It's certainly not small. We can haul 5 people + a decent amount of...

Do you mean data encrypted and you need to mirror that data (moving keys, certificates, etc) or do you mean encrypting the data sent over the mirroring link?

Honestly this sounds like a perfect place for Service Broker. Send a message to a Q from the app, the message will route and kick off the proc/query. Then have...

Be sure that you are running transaction log backups as well if you are in full recovery model. you can add this to the maintenance plan.

Very interesting and nice fix. Thanks for the update!

You can also script this stuff out and then put it in to a job. SSIS might be overkill, depending on what you need.

Please show us some of what you've...

You do not want to shrink the database. It causes fragmentation and messes with the index efficiency. If you need to shrink the log, shrink those files only.

It's not quite clear what you want. your query doesn't reference users at all.

This almost seems like homework. Please make an attempt against users and show what is confusing or...

It's the same as two tables. You put a join in between those tables.

select x, y

from a, b, c

where a.x = b.x

and a.y *= c.y

just list the...

I'd say that you should wrap them in an IF clause, but if you can't add a parameter or logic, that might not help.

Are the print statements used? If not,...

Adding a post to the virtual briefcase has been discussed and it's on the list. Not sure where we are on priority.

Are you trying to sort all threads instead of...

Joe,

Apologies for missing this the last couple days.

It's a good idea. What about an "On the Edge" section with forums for HA, VMs, DR, VLDBs, etc?

Ryan,

Thanks for the response and appreciate your insight and opinion. I'm sure that the testing part is hard and I don't have a solution to implement it. I can definitely...