Forgive us our typos. Absolutely. The most you'd get gigged for only going to 99 is some good natured ribbing about being premature or something.

It's amazing how much discussion what...

Yikes.

I haven't seen that many GOTO's in quite a while. Nice job.

WOO HOO!

A CLR solution. Thanks Adam.

Absolutely more appropriate languages than SQL. I'm not serious about putting this on an interview. This was just some geek fun that we had one morning at work. Actually we...

Oh boo. That's so procedural. Not set based at all.

What? Are you some kind of developer or something?

Nice job though.

I had this query from Itzik too. I didn't want to use it in relation to the article. It works really well for populating a table of numbers, which, as...

WHOA!

Great post. Very nice solution. Scalable. That was something I honestly hadn't thought of. We were just having fun with the problem statement. But, in my, and my co-worker's, defense,...

Nice query, violated the rules though.

Nice. I like it. Simple, clean. Good job.

I wouldn't recommend passing executable strings to the database just because each execution gets it's own plan. You want the system to reuse plans. Most of the time, in most...

No arguments there. We had a proc that was so poorly written that it took about 3 minutes to recompile. It too was called thousands of times a minute and...

And, if you do decide to split them, you can still use the original proc as a wrapper around the other two so that you don't have to re-write your...

I think you've already answered your own question. If the optimizer can generate a plan that kills performance then you need a method to avoid this. You could try forcing...

This is a part of Analysis Services. According to the books online you can turn this off through the Properties of the server in SSMS.

I did tech support for a bank in the early 90's and had to wear a suit & tie while pulling cable and crawling under desks. Dumbest damn thing in...