Wim,

Good luck and be sure you think through the additional benefits the consulting company gives you as well as downtime. That's the reason the rate is high. If the client...

Leave it as full

Add transaction log backups

Use INIT, do not pile backups on top of another in one file.

Are these all on local drives? Or are some network?

I'm with Will. That's how I handle things, though I'm usually a select top 10 * from xxxx

for myself.

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