Today I will write just a short blog post to do a quick reminder! I still hear a lot of people suggesting CTEs because they think it works like a temporary table (you populate the table and then it can be/is reutilized). It doesn’t! From de documentation: Maybe they are focusing on the “temporary” word. Using the CTE two times will perform two different executions! Don’t believe me? See the next example!

Continue reading

Author's picture

Cláudio Silva

Data Platform Architect and PowerShell lover.

Data Platform Architect

Portugal