Nice job Sushila.... I use EM to troubleshoot other people's more complex joins and, occasionally, to make my own. And, I "steal" code from it and QA quite a bit for the sake of speed as you suggested. You and Erik are correct... when I was a newbie and found out how to do those things, it was about as good as Christmas.
I've been busy enough where I haven't paid much attention to Yukon and was disappointed to hear (in your article) the EM is going away. Perhaps another article that compares some of the tools like EM between 2000 and Yukon would be worthwhile.
Thanks for the article and the forum answers you've posted. They help Newbies and Oldbies alike.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs