As many people have answered, you have to get on the ground at the new office and start looking over the environment. I'd ask for resources to get going.

On the...

Things could be out of sync here. An index rebuild/statistics update should fix things.

They should, and I'll take a look.

The instance does not need to be restarted at all. That's overkill. The next comment issued by the connection will have the limits enforced.

The reconfigure is needed, but you...

Haven't read that one, but I did have one called "Data Modeling" that I read years ago and liked. There's a new one from Eric Johnson and Josh Jones that...

GROUP BY the other fields. I think that will get you where you want to be.

Somewhere there is a default location for data and log files.

No worries, after you've installed it, you can change this. Right click server, properties, database properties. You can choose...

tempdb should always be in simple mode. If it's growing large, you have a large transaction, or open transactions.

dbcc opentran will look for open ones.

For large ones, not much you...

No idea here. Is the schema changed between the old and new databases?

select @@servername

The links have been changed to the Resources section at the bottom of the article.

You need to perform that log backup before shrink will work. The active transactions (committed, not backed up), need to be removed.

A logreader would be the only thing. There's no other way to do this without adding a column.

You could add a column with a default, which might work for you....

Jeff,

You should get clarification from MS. They can be funny about this.

My understanding is you can use Dev for yourself, but everyone else needs a CAL to hit it as...

It's not in the permission list. Appears only moderators and admins can do this.