Oh, and furthermore, this inefficiency didn't start having such dire effects until the table it was querying went from a couple thousand, to a couple million records.

I've googled for this on several occasions, but not really found any good information. I have a SQL 2005 CLR procedure that builds dynamic (parameterized) SQL. I basically have a main statement, and a ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Prevent AI-generated tech debt with Skeleton ...