I'd agree with Mr. Moden and Mr Young on using lookup tables. And I'd encourage one of them to write something up on this.

Josh, If you have a URL, we'd...

I like the first suggestion from Jack, if that fits your business need. You want to be sure you won't have issues if the data grows to 5 (or more)...

user_name()

suser_sname()

Depends on what you want.

Best of luck.

I haven't tried the CBTs, so can't recommend one.

One other thing I'd suggest is that you work as a group, study style, and help each other.

I thought that test servers didn't need a 2nd license, in which case you could drop Enterprise there.

If not, developer edition makes sense.

It was introduced for data warehouses and cubes, offering savings if you store significant amounts of decimal data.

I think there are performance monitor counters for reads/writes for tempdb and full text.

Barry, thanks and feel free to complain. I know it's well meant from many of you.

The others, I tend to ignore, or argue if I think I can annoy them...

I lived in Carlsbad for a year. It's nice, but $$$. Also too windy and no winter, bugged me.

I think Denver is amazing, but no water. However we have enough...

First, read Jack Corbett's blog entry. http://wiseman-wiseguy.blogspot.com/2009/08/no-training-budget-still-no-excuse.html

Second, I'd honestly say that most of the exercises and things you need to do are practice with concepts. I'd recommend that you get...

I would second Paul's advice. Figure out if tempdb or the FT catalogs take more IO and move them. I'd be betting on tempdb, but check it.

I've never heard of it either, so I'm guessing typo.

Let us know if we're wrong.

Here's a great article from MVP Gail Shaw: http://www.sqlservercentral.com/articles/64582/

One thing you can think about is changing your process to commit at smaller intervals. If you can do that, the log...

What are you trying to accomplish overall? It sounds like mirroring might be a good solution for you. Only the active changes will move over.

I sent this thread to the publishing team today with a request for comments. I spoke with someone today as well about some of the ideas.

The disclaimer is likely something...