Eirikur Eiriksson (8/24/2014)
TomThomson (8/24/2014)
Jeff Moden (8/23/2014)
There's nothing wrong with challenging a DA when it comes to performanceup to there I agree with you 100%
because, and with absolutely no malice in my heart, DAs don't actually need to know how to write a lick of code, never mind high performance code, to do their jobs correctly.
And I don't agree with that at all; a DA had better be able to produce a schema design which enables high-performance code to be written, and if the DA knows nothing about code and in particular nothing about high performance code that DA is not going to be able to do that.
We wouldn't want to leave the design of the internals of a building to the builders would we?
😎
No, and neither would I want to use a coder (as opposed to a developer) to design code. But I wouldn't want to use an architect who didn't know about about joins and unions and projections and restrictions and filters and intersections and symmetric differences and so on to design a database - and if someone knows about all those things they can presumably write relational expressions in some notation, even if that notation isn't SQL or T-SQL.
edit; typos
Tom