Antares:  Did you mean "Get one separate raid set to put both tempdb and logs on" or "Get two additional raid sets to put tempdb and logs on"?

Seems to me...

I keep thinking that there has to be a lower limit on intelligence, because the person is obviously still breathing, but I keep finding myself proved wrong.

You rock Steve.  Every...

It's quite easy to build true, reusable command objects in VB.  We do it this way (this is an update only command, so no return parameters:

Static cmdUpdate as adodb.command

      If cmdUpdate...

For SQL Server, just use DBCC PinTable.  I'm assuming that this is a demo project, not a full fledged production process.  SQL Server will still write changes to disk, but...

If this is the problem, (which I don't doubt, and will find out late at night or this weekend), what good is the setting in EM under maintenance plans that...

Cindy's base question was:   "If it does have to do a repair, does it show up in the log?"

I understand your thoughts on "automatic repairs" but what is the answer...

Steve made one very good point in his article, which you don't want to lose as this thread drifts away from joins to nulls.  The article was not about how...

At least for the two "live" datacenters, the easiest, most reliable solution is merge replication.  That's exactly what it was intended for.

By definition - a lookup table is going to be the object of joins and/or where clauses.

Select P.Name, D.Description from Product P Left Join Descriptions D on P.DescriptionID = D.ID

would...

For this exact set of conditions - a LOOKUP table that is probably added to/updated rather infrequently; you've ruled out ever using replication; you've decided that an Identity column is a...

As far as I can tell, yes, it is the fact that they are entirely artificial values that most bothers the folks that it bothers at all.

Also, the identity property...

The Primary Key has to be a unique, unchanging value.  In a perfect world, there would be a "natural key" in any table and you wouldn't need to add a "surrogate...

This setup seems to me to be a textbook case for using replication.  Use transactional or snapshot replication to make a one-way copy that is updated hourly, daily or whenever. ...

Well, as long as we're being picky, it defaults to 50 when you're using EM to define a field too.

But, if you take the question literally as presented, the answer...

Yeah, I noticed that too.  Probably what SQL - 2005 was supposed to be!

I also saw a new feature that I think I'll really like

Declare @i varchar(max)

Gives you a rather...