Skip to content
Reckon Analytics
Reckon Analytics

Reckon Analytics

Its All About Analytics

  • Home
  • Blog
    • Python
    • Tableau
    • Power BI
  • About Us
    • Deepak
    • Shruti
  • Contact

Tag: SQL

Posted on September 5, 2019

Six Simple Steps to Improve Stored Procedures in SQL Server

1. SET NOCOUNT ON: Stop the message that shows the count of rows affected by a T-SQL statments. These messages can be suppressed with SET NOCOUNT ON and can increase performance by decreasing network traffic 2. IF EXISTS(): Use IF EXISTS() to check if data exist in a table or not. You can write something …

Continue reading "Six Simple Steps to Improve Stored Procedures in SQL Server"

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 137 other followers

  • 14,880 visitors

Archives

  • Facebook
  • Twitter
  • Linkedin
  • Instagram
  • Youtube
Create a website or blog at WordPress.com
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy