patrickmcginnis59 10839 (5/13/2013)
dmbaker (5/13/2013)
vliet (5/13/2013)
Developers think row-based. They cannot work with set-based algorithms. Everyone who tells you otherwise hasn't worked together with developers.Really? That's a pretty broad brush you're using there. I don't claim to be an expert by any means, but as a SQL Server developer I think I know "set-based algorithms". But then, I guess I'm just fooling everyone...I am a developer after all.
🙂
Would SQL query and update statements (without looping and other RBAR constructs) really even be qualified to be called "algorithms" of any sort?
I was wondering the same thing, that's why I used "quotey fingers".
Google definition:
al·go·rithm
/'alg??riT?H?m/Noun
A process or set of rules to be followed in calculations or other problem-solving operations, esp. by a computer.
If you think of a SQL query as a "set of rules" then I think "algorithm" absolutely applies. The "process" part may be abstracted away (being performed all or in part by the engine), but you still set up the rules in your query.
I dunno.