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...

Me too. I've never heard the phrase "reuse logs" applied to SQL Server.

I mean, we "reuse" them all the time. The same log file is cleaned out, whether you're in...

If it's that severe, you might want to try "turning off" parallelism by setting the MAXDOP to 1 for the server, but it's just a band-aid at this point.

If this...

It's an advanced setting within the properties of the server. The default is usually zero.

This is the script from BOL

sp_configure 'show advanced options', 1;

GO

RECONFIGURE WITH OVERRIDE;

GO

sp_configure 'max degree of parallelism',...

ALTER DATABASE dbname

SET RECOVERY SIMPLE

2008 does have intellisense. So far, I've found RedGate's to be better.

That's just what I was going to point out. I even went & checked it in BOL.

No. This wouldn't be helpful to you at all. In fact, it would probably hurt performance.