RE: Project suggestion for a noob

SSC Guru

Points: 1003857

July 3, 2015 at 11:48 pm

paul.knibbs (5/18/2015)
Jeff Moden (5/16/2015)About 8 months ago I interviewed a handful of "developers" and a couple of "senior DBAs" that didn't know that ROW_NUMBER() even existed.
Well, to be fair, if all their development or DBA experience was on SQL 2000 or earlier, that would be reasonable. 🙂

Heh... to be fair, if they're a Sr. Developer or Sr. DBA, it's not reasonable for them to not even know that it exists. It demonstrates absolutely no self-improvement motivation nor even intellectual curiosity and those are two traits that I place high value on for Sr.'s. Consider how big an improvement the ranking/aggregating functions were in 2005, a person that comes up with goose eggs on something like that isn't someone that I'd want to hire.

--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)