RE: How to run your CTE just once, and re-use the output

There’s an excellent article “How to run your CTE just once, and re-use the output” over at sqlsunday.com, but a few people on Reddit are wondering if inserting into a #temp table or @table variable would be any better [for performance]. As Brent Ozar is fond [paraphrasing!] of saying, “If you don’t know, you’re wasting your… Continue reading RE: How to run your CTE just once, and re-use the output

The 4 pillars of OOP (Object Oriented Programming) summed up in my own words.

Encapsulation – The process of hiding internal data away from other classes. Abstraction – The process of hiding irrelevant details while providing a feature.(with the side effect of reducing the code complexity.) Inheritance – The process of providing properties and methods to derived classes. Polymorphism – The ability of a derived class to take on… Continue reading The 4 pillars of OOP (Object Oriented Programming) summed up in my own words.