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

The noise from those things is annoying. I wish they'd block them from the broadcast. I watched a touch of US/Ghana and Eng/Ger and it was very, very annoying. I'd...

It happens in basketball as well. People flopping, which annoys me just as much. I like it when the referees let them play more, but what I don't like is...

And add a couple more referees to watch out for it. You'll never get away from it completely, someone will gamble they'll get a call. But if you have 3...