Last night I came across a question posted on Experts Exchange website. The user was asking which performance would be better, case when or union. It is a very interesting question, and a lot professionals give their opinions. (well without elaborating or explain it) and the verified so called “best” answer, that developer very firmly announced… Continue reading SQL Query Performance of union & case