Popular Posts

  • The Basics of Good T-SQL Coding Style – Part 4: Performance
    SQLServerCentral.com Articles The Basics of Good T-SQL Coding Style – Part 4: Performance There are several obvious problems with p...
  • Adding to Lists
    SQLServerCentral » Latest topics Adding to Lists Comments posted to this topic are about the item [B] Adding to Lists [/B] more in...
  • A Backup Change
    SQLServerCentral » Latest topics A Backup Change Comments posted to this topic are about the item [B] A Backup Change [/B] more in...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Thursday, October 12, 2017

The Basics of Good T-SQL Coding Style – Part 4: Performance

SQLServerCentral.com Articles
The Basics of Good T-SQL Coding Style – Part 4: Performance

There are several obvious problems with poor SQL Coding habits. It can make code difficult to maintain, or can confuse your team colleagues. It can make refactoring a chore or make testing difficult. The most serious problem is poor performance. You can write SQL that looks beautiful but performs sluggishly, or interferes with other threads. A busy database developer adopts good habits so as to avoid staring at execution plans. Rob Sheldon gives some examples.

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)