Skip to content
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 subscribers
  • Facebook
  • Twitter
  • Linkedin
  • Instagram
  • Youtube
Create a website or blog at WordPress.com
  • Follow Following
    • Reckon Analytics
    • Already have a WordPress.com account? Log in now.
    • Reckon Analytics
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
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