What is the advantage of using Set NOCOUNT ON in stored procedure s which are used in ssis packages

0 votes
While studying SQL Server's performance tuning concepts, I discovered that using SET NOCOUNT ON in the first line of a stored procedure and then setting it back to SET NOCOUNT OFF in the last line will assist to enhance performance.

How would that be useful when utilizing the stored procedure with an SSIS package, I wonder?
Aug 28 in Database by Kithuzzz
• 11,640 points
17 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
1 answer

What are the different types of keys used in the database?

There are mainly 5 types of Keys, ...READ MORE

answered Nov 19, 2018 in Database by Sahiti
• 6,380 points
2,269 views
0 votes
0 answers

What is the purpose of using WHERE 1=1 in SQL statements?

Possible Duplicates: Why would a sql query have ...READ MORE

Aug 28 in Database by Kithuzzz
• 11,640 points
33 views
0 votes
1 answer

What are stored procedures in database?

A stored procedure is a collection of ...READ MORE

answered Sep 6, 2018 in Database by CodingByHeart77
• 3,720 points
593 views
0 votes
2 answers

What are the ways to get the count of records in a table

With the help of the SQL count ...READ MORE

answered Aug 20, 2020 in Database by Okugbe
• 280 points
2,255 views
0 votes
1 answer

Which operator is used in the query for pattern matching?

LIKE operator is used for pattern matching, ...READ MORE

answered Oct 15, 2018 in Database by DataKing99
• 8,240 points
16,508 views
0 votes
1 answer

What are set operations used in database?

There are mainly three set operations: UNION, ...READ MORE

answered Nov 19, 2018 in Database by Sahiti
• 6,380 points
1,490 views
0 votes
0 answers

How to update Identity Column in SQL Server?

With 200 records currently, I want to ...READ MORE

Aug 9 in Database by Kithuzzz
• 11,640 points
159 views
0 votes
0 answers

Simple DateTime sql query

How do I query the DateTime database ...READ MORE

Aug 12 in Database by Kithuzzz
• 11,640 points
22 views
0 votes
0 answers

How can I select the first day of a month in SQL?

I only need to choose the given ...READ MORE

Aug 14 in Database by Kithuzzz
• 11,640 points
25 views
0 votes
0 answers

CROSS JOIN vs INNER JOIN in SQL

What is the difference between CROSS JOIN and INNER JOIN? CROSS ...READ MORE

Aug 18 in Database by Kithuzzz
• 11,640 points
19 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP