Sunday, April 20, 2014

Performance - Stored Procedure versus inline


Re calling stored procedure directly, I know. But for my requirements I need to call it via an EXEC since it is being invoked from a CLR routine.



Then you should measure it from a CLR stored procedure, and you should use the approiate CommandType for the two cases.





Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

No comments:

Post a Comment