Thanks for the article. I'm interested in understanding different design schemes. My question may have already been answered, but I'm not sure.

For the first time, I'm considering an...

Dave: Thanks for the feedback!

I appreciate the article for it's nice high-level summary of issues to consider combined with easy to understand, detailed examples.

I have one suggestion/question/tweak. This is not a criticism, just...

Thanks for the additional reply. I wish there was an easy escape character or set of characters to say "hey, please print this text as-shown". Sort of like...

Matt: Great tip! I used it on my earlier post and it worked. Thanks.

Mike: Thanks for looking into it. Glad to know I didn't miss something terribly obvious.

re: "replace required on certain characters. "

I would add: & # x 0 D ;...

Mike: I'd be interested to know if you ever get the TYPE option to work. I had read about it and tried it, but it never worked for me....

Matt: I've run into that very problem on more than one occasion. Sometimes I do a replace() to fix the problem. Sometimes I can change the text...

Like others, I love CTEs and use them a lot as an alternative to derived tables. As stated, CTEs are great when the dataset is needed more than once...

Jeff,

I love articles like this that do such a good job of explaining things step by step. I particularly appreciate the real-life example by taking...

Fun article and great discussion. Thanks.

I echo other posters in stressing simple and easy to use features over focusing on "look and feel".

The feature I wish for most is a way to "subscribe"?...

I appreciated the idea in this article.

I thought I would also share another option. I routinely re-create my databases from scratch when I need to make major...

Awesome intro! Not having any need for data warehousing at my agency, I haven't had a chance to learn much about the topic. However, I have a feeling...

Thank you for continuing to support this great site. I appreciate it.