I agree -- that certainly qualifies as bad advice (particularly without making sure that a backup of the .MDF is made, so that the commercial product probably won't be able...

Other than the fact that it was an advertisement for a commercial product, what was particularly incorrect on the page you referenced?

I haven't (yet) gone to that page because of your comment. I for one WOULD like to know what's not right.

Am I crazy to think that anything that causes...

I certainly am surprised by that. I'd love to have a copy of the article. How best can I get my email address to you without it going...

If you rearrange each clause so that the test is

(@parameter is null or column = @parameter)

it won't ever look at the column values when...