Slight correction. It goes out edited in the next day's newsletter if it's not already scheduled. Sometimes we are scheduled out 2-3 days in a row.

Once it's edited on the site, it will go out as the corrected version.

Here is fine.

I think I agree with Paul. I'm not sure partitioning helps.

Partitioning helps with administration, and with archiving and adding data, but not with queries themselves. To get a big improvement,...

No, I be going nowhere soon. I have...

I've had companies write this into an agreement for things like PASS for me. I think it's fair. If they are paying for you, they deserve some benefit.

I've had friends...

It seems you have a few issues.

First, I would definitely have some type of CustomerID, probably a separate table that has basic information about what a "customer" is and have...

You can, some people find it easier to backup/restore. I don't think it much matters. Was just giving another option.

You can also detach the dbs, and then restore a backup using the WITH MOVE option.

I can't think of there being a better way than a VPN tunnel. Anything else would likely be just as much a hassle. Third party products would be a variation...

It looks like you are missing a bracket here. If you are posting stuff, be sure that you cut/paste, not type so that we can get an idea.

SQL Agent will...

I'm not sure where you are getting db_id? Is it the code above there? SQL doesn't map things. That column would have to be returned by a query.

As I mentioned,...

The command and the query you show are two different databases.

Are you running this from a command line or SSMS? A job?

Is this a linked server?

I'm trying to understand...

Surprised.

@BrentO going to SQLSkills.

Definitely want to make rewards more random, and given from mgmt, not expected as part of the job.

An interesting link from TED on motivation: http://www.ted.com/talks/dan_pink_on_motivation.html