All my objections to the article were covered by other respondents, save one.
Is it really a valid argument that CTE improves readability? There are serious limitations of that functionality...
I'm not pro nor con CTE - as everything it has it's uses, but more often than not I encounter a POV - mostly from analysts of all sorts and stripes - that states: "CTE is easier to read than subquery" or similar. I don't believe that this ever should be any serious argument for (or against) any solution, let alone one that can - if written badly - bring entire server to it's knees...
I also recently encountered a POV that one should ditch temp tables in favor of CTEs because "temptables are outdated".
My personal opinion is that if you use either CTE, subquery or Temptable to make complicated code more readable or manageable, and you are an analyst, then your query could use overhaul...
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
All my objections to the article were covered by other respondents, save one.
Is it really a valid argument that CTE improves readability? There are serious limitations of that functionality...
I'm not pro nor con CTE - as everything it has it's uses, but more often than not I encounter a POV - mostly from analysts of all sorts and stripes - that states: "CTE is easier to read than subquery" or similar. I don't believe that this ever should be any serious argument for (or against) any solution, let alone one that can - if written badly - bring entire server to it's knees...
I also recently encountered a POV that one should ditch temp tables in favor of CTEs because "temptables are outdated".
My personal opinion is that if you use either CTE, subquery or Temptable to make complicated code more readable or manageable, and you are an analyst, then your query could use overhaul...