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

Guiness is OK, still not as good as a real ale. Corona? Blech! The best beer out of Ol Mehico is Bohemia. Great stuff. Hold the friggin' lime.

Actually, I haddn't thought of that, but yeah, in most cases this is probably quicker.

Ooh, Steve, if you're taking orders, grab a keg of something... how about Ruddles County. If not that, use your judgement.

I'm jealous Steve. English beer... Mmmmmm! A few pints of real ale and I'll hug everybody.

Looks like the SuppContacts table has one row for email with phone null & one row for phone with email null? Better design would probably be to seperate these into...