formatting

Script

HTML Table formatted results of a view or table for emailing

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2018-02-19 (first published: 2018-02-07)

931 reads

Discuss

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

by Additional Articles

SimpleTalk

T-SQL

Article

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.

2017-10-05

6,056 reads

The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects

by Additional Articles

SimpleTalk

T-SQL

Article

Technical debt is a real problem in database development, where corners have been cut in the rush to keep to dates. The result may work but the problems are in the details: such things as inconsistent naming of objects, or of defining columns; sloppy use of data types, archaic syntax or obsolete system functions. With databases, technical debt is even harder to pay back. Robert Sheldon explains how and why you can get it right first time instead.

2017-07-25

5,860 reads

The Basics of Good T-SQL Coding Style

by Additional Articles

SimpleTalk

T-SQL

Article

TSQL Code must work properly and efficiently. That's not enough though. Unless you are working alone, have perfect memory and plan to never change job, then you need to comment and document your code, it must be inherently readable, well laid out, use informative and obvious names, and it must be robust and resilient; written defensively. It must not rely on deprecated features of SQL Server, or assume particular database settings. Robert Sheldon starts a series of articles that explains the basics.

2017-07-05

7,732 reads

How to style your SQL using SQL Prompt’s new formatting options

by Additional Articles

Redgate

formatting

Article

Prefer tabs but your teammates use spaces? That's not a problem with the brand new formatting options in SQL Prompt. It's now possible to customize, save, and share multiple styles that you can then quickly switch between when working. Here's how it works, and how to get set up.

2017-06-06

4,008 reads

How to implement a T-SQL code formatting standard using SQL Prompt

by Additional Articles

Redgate

formatting

Article

Louis Davidson shows how to save a defined SQL formatting style as a shareable template that you can quickly share with your coworkers.

2017-05-02

5,605 reads

Who the Devil Wrote This SQL Code?

by Additional Articles

SimpleTalk

formatting

Article

The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your work. It is never a good experience to see SQL Code, cry out “Who the devil wrote this code?”, and then realise that it was you. Grant gives some examples of bad formatting and explains why you should never check-in badly-formatted SQL code.

2016-11-29

6,105 reads

Formatting SQL Code - Part the Second

by Additional Articles

SimpleTalk

simple talk

Article

When you're formatting SQL Code, your objective is to make the code as easy to read with understanding as is possible, in a way that errors stand out. The extra time it takes to write code in an accessible way is far less than the time saved by the poor soul in the future, possibly yourself, when maintaining or enhancing the code. There isn't a single 'best practice, but the general principles, such as being consistent, are well-established. Joe Celko gives his take on a controversial topic.

2016-08-30

8,612 reads