On the million record test data... I know what I'm doing today:-D
Do you use a While Loop or Recursive CTE to make your test data?
Thanks so much for your reply Mr. Modden.
Heh... just a tip from an old dude that has seen a whole lot of water pass under the proverbial bridge... THAT's the one thing that you should absolutely sweat bullets over. While it's good to be humble and thankful, spell the name of your boss, other higher-up, or even a peer incorrectly and see how many points you earn especially if the name has only 5 characters in it. ;-) Personally, I'm not insulted outside the work-place but wanted to tell you that a whole lot of people are much more sensitive to it. I've found that such a simple faux paux in communications will cause many higher-ups to think "Gee... what kind of attention-to-detail does the person really have when they won't even take the time to spell my name correctly?' I also take the time to learn to pronounce even difficult names correctly. While some claim to understand and accept mispronunciation of their complex names simply because they are complex, you can really get their attention and develop incredible working relationships just by taking the time to show them they're important enough to learn to pronounce their difficult name correctly.
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