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.

There is not. It's too much overhead to encrypt all data in there database by table. There are quite a few encryption options for columns.

In SQL Server 2008, there is...

I don't see an option to allow this, but I'll ping the InstantForum team.

I think that some of the crazy shipping stuff will come to a close. Still not sure if overnighting things from Amazon makes sense, but there's probably some hybrid models...

That "editorial" isn't fact, it's an inflammatory piece. It got widely picked up for that reason and there have been some stories that show a Prius is not worse than...