I have to agree with the majority of posters here. I installed it but haven't really found it to be beneficial.

It hasn't been a real resource hog that I've...

Thanks for the enlightening article about RAISEERROR.  I just wanted to point out a couple things.

I think there's a typo in the very last example.  The line is:

SET @sMessage =...

Just some constructive criticism on how to reword the question so it is more clear.

The question is a Yes-No question but there are four answers.  I would reword the question...

I was so distracted by the inner join that I missed the part about only one row being inserted.  I figured that no rows would ever be inserted because of that...

It would be nice if you also showed how to clear the sp cache so you can run the results over and over and compare.  I think the commands are...

I can't help you there, I don't know how to pull the table name up as a column. It seems like if you have a bunch of identically structured...

A cheap way to do it would be in the union statement:

SELECT Table = "Table1", * FROM Table1

UNION

SELECT Table = "Table2", * FROM Table2

UNION

SELECT Table = "Table3", * FROM Table3

Not...

If I recall correctly, you can use UNION ALL instead of UNION and it should increase your performance slightly.

-Aaron

I'd like it if there was only a warning if there was an actual change in the question. Otherwise it's like crying wolf everytime. I too answered 8GB...

Don't forget at the top of the "View job History" dialog, there is a checkbox to view the step details. I always miss that one. If you turn...