Ran a query on a prod server for 50 minutes before realizing I forgot to put my exclusions in the results... Oops.... New query runs in 1.5min. 4500 rows from the potential 340k rows.

What the heck kind of query takes so long?

@spongessuck big data man... Lol. We're taking kvp data stored in a database and pivoting it with certain keys to make the keys the columns. Oddly though according to performance tools I later found out that's not even what tales up the majority of the time. It's the inserts into a temp table.