Trouble-shooting T-SQL which runs fast but the Sproc is slow (link) Jan 10, 2014 Lincoln Bovee' Setting ANSI_NULLS ON will make make the Sprocs run fast. See this article: Query is fast but Sproc is slow Views – 1729