RE: The Scientific Method: a call to action

SSC Guru

Points: 1003894

June 12, 2015 at 2:33 pm

With that in mind and for those people that exclaim, "OK. You sold me. Where the hell do you get a million rows of test data?", the answer is that it's simple and quick to make your own. Please see the following two articles for a good introduction to the art and then use your imagination.

http://www.sqlservercentral.com/articles/Data+Generation/87901/

http://www.sqlservercentral.com/articles/Test+Data/88964/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)