SQL Optimization Tip [Tip/Trick]
Last Updated: 16 Nov 2009
Page Views: 186
Rating: 4.00/5
Votes: 3
Popularity: 1.91
Bookmark Count: 0
Licence: The Code Project Open License (CPOL)
Use SET NOCOUNT ONWhenever we write any procedure and execute it a message appears in message window that shows no of rows affected with the statement written in the procedure and we become very happy to see that our procedure is working. But do you know that this message creates an extra overhead o