This post comes off the back of my last, where I looked at issues caused by explicitly declaring a large number of values in an IN clause. The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause. My... Continue Reading →
Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join
SQL Undercover 