I have a query which is super fast in SQL Server Management Studio and super slow when run under sp_ExecuteSQL.
Is this to do with caching of execution plans not happening when run under sp_ExecuteSQL?