All this time i though SET NONCOUNT ON is fater than OFF .. it is not .. there is a big dealy when you use ON.
check out
Performance Effects of NOCOUNT
http://www.sqlservercentral.com/columnists/dpoole/2751.asp
Friday, December 22, 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment