Miles - your comment interested me but I would like to expand to see if what I am thinking is aligned to your comment (I want to be sure...

I did find this article very informative and, I believe, explained a seemingly complex subject quite well. But then again, I am not by training a DBA - I...

I am having some "drinking from the firehose" moments where situation dictates I have to learn some things quickly and have limited tolerance for error. Hopefully, I can state...

Let me set down my cane so I can use both hands to bang out this message...

To quote myself "Never confuse motion with progress" which in the world communication transmogrifies...

Giving away my hand - I will always lean towards efficiency. I don't understand the phrase good enough. That seems self-defeating. You are knowingly leaving in errors....

What you are saying is true. In the real world where this code was snatched from with a little bit of salty refactoring I avoided this process entirely. ...

That is an excellent solution!

I have tried the more dynamic lookup suggested earlier with both a fixed table and the table variable. Interestingly enough there is not a significant difference in the timing.

For...

Agreed. This is another perfectly viable method. Putting it through the same Iteration test it comes out as the third slowest (23 microseconds per iteration). If having...

First "ME"? Off the point I guess but anyone else try to integrate products into Windows Bob. It sounded great until I actually saw it.

There are certain products...

Sounds like a painful rendition of That Ol' job Security" (Sung to the tune of That Old Black Magic)

" That old Job Security has got me Stuck Again

They...

Julie,

I agree with the importance of all the things you mention. Some of them I like to put in the basket of company strategic plan. Maintaining an IT...

Two things to respond to:

Workflow I feel that the build vs buy decision (size and urgency plays a part as well) is really told in the process modelling. This...

Thank you fo rbringing this to the surface - "airing it out" so to speak.

I grew up in a family of "huggers" and am one myself. I prize and...

I have found this thread very interesting and maybe for some a little purgative. I think it underscores that it is not what you learn but what you do with...