Category best practices

sql best practices, including sql coding style guidelines, sql formatting guidelines.

best practices, SQL language

SQL Server Best Practices: [dbo] vs. dbo – A Guide to Consistency

When browsing through SQL scripts, you’ve likely seen schema-qualified table names written in two distinct ways: dbo.MyTable and [dbo].[MyTable]. Functionally, they often seem to produce the same result, which begs the question: Does it matter which one you use? And…

James
October 20, 2025

best practices, sql

A list of SQL best practices

Here are some SQL programming guidelines and best practices we collected, keeping quality, performance and maintainability in mind. This list is not complete at this moment, and will be constantly updated. Do not use SELECT * in your queries. Always…

admin
September 27, 2011