This seems to be either a controversial or overly-technical topic: should you use WITH (a common table expression a.k.a. CTE) or a TEMP TABLE. Both can serve similar purposes but each has their own strengths and weaknesses in how they work with other aspects of your query or procedure.
So today we’ll take a look at both without going into crazy detail but covering at least the basics.
According to GlassDoor, Data Scientists have the best work-life balance of all professions. Go us! And with thousands of Data Science positions out there in dozens of fields, it’s no wonder that we’re a growing group.
“What makes being a Data Scientist so great?”, you might ask. Well, lots of things. Here are the top 5 reasons why I love my job as a Data Scientist. Continue reading