You really should have a clustered index, but since you get only one, you need to make sure you put it in the right place. The PK is clustered by...

One thing we've found that is a great advantage in 2005 when working with different functionality within a single app, is to take advantage of schemas. In your case, you...

I've done exactly that type of installation.

Yes, it causes problems. The 2008 install does something to the 2005 install that causes errors when you go to load the GUI for...

Yelling (all caps) is hardly necessary.

This link is to the general "How To" topic in Books Online.

This link is to the RESTORE topic in BOL.

Yelling at the people trying to...

I agree with Andy. I need the request written down in some fashion. If there is a policy in place and this violates it, I'm going to fall back on...

Honestly, contact Microsoft because your licensing scheme is not going to be the same as mine. We have an enterprise license for TFS that allows us pretty much unlimited use,...

The order by is a serious puzzler. If the performance was OK, I'd probably ignore it with a shrug, but if performance was in any way an issue, it sure...

The error is explaining the problem. The subquery is being used as a column, that means it has to return a single row because you can't have two or more...

The really beautiful thing about it was that the SET @var = 0 was directly butt up against the IF statement. It wasn't like there was 15 pages of intervening...

We found one in production earlier this year that looked a bit like this:

DECLARE @var int

SET @var = 0

IF @var > 0

BEGIN

...do some work

END

return 0

And they had honestly spent a...

Indexing for data retrieval would be my biggest concern. Why would you store... anything, in a column like that?

Personally, I'd probably look to storing the stuff as XML instead of...

It's possible they're remove it in the future. I'm looking at the 2008 documentation. It's there and says the same thing. It's pretty basic functionality, generate a script. Even if...

I know I could be off, but that sure looks like homework.

If you post what you tried that didn't work, you're sure to get help. Just trolling for someone to...

"Should get paid" ?

I thought Steve was paying us for this?

Hey, get that guy over here...

😎

The key word and tricky phrase to take away from the description of this column in books online is: "... reuse of transaction log space..." This means that it will...