Let me get this straight:CORRECT
You stumbled over some new features.
. In the Microsoft course material
You glanced at books online
Did a bit more than glance and also read what little was available in 2009. Not sure when the Wikipedia article originated as it doesn't have an original date, only a modified date in 2011.
I read BOL and the Microsoft course notes plus the standard Googling. What was available looked very like the "Other editions SQL2005" version on BOL.
You put together some trivial tests against a trivial database
. I did say it was Adventureworks. The whole point of using Adventureworks is that is a publicly available database. Any tests or experiments run on Adventureworks can be easily repeated and therefore verified by developers and DBAs of all levels of ability.
You decide you are now enough of an expert to write an article about it
No, I was asked by the people being put through the course what these operators were and as I hadn't seen them before I did some digging and basic experimenting.
As with any experiment
1. Document the experiment so it is repeatable and up for critique.
2. Document the results so they are verifiable
I don't have the attitude of expecting people to bask in my magnificence. I'm not that arrogant.
What I want to achieve in any article
1. Pass on what I have learnt to those coming up the ranks being very clear about my methods and experiments
2. Provoke response from the many ahead of me in the ranks so that I learn more.
Actually the forum responses did teach me something
select fieldlist from OriginalSource query Where qualifying criteria is met
select fieldlist from Targettable
Very useful in data warehouse reconcilliation.
I was arrogant enough to think that I could add some clarity to BOL.
Instead you went on the assumption that if you could find good uses for the features then there were no good uses for them.
I can't recall making that assumption, it certainly doesn't say anything about assumptions in the article?
Again the article and results are up for critique and as per the responses in the forum the true use for these operators was revealled.
I will let you supply the adjective for that attitude.
I don't have that attitude, never have had, never will have. You are very much holding the wrong end of the stick and no, I am not making the assumption that it is a stick in your hand.
LinkedIn ProfileNewbie on www.simple-talk.com