Architecture & Performance
SQL Server3 January 20221 min readArticle in English

150 T-SQL Bad Practices

Many times i was asking for given best practices for T SQL code but I don't like best practices advices. They can be deprecated faster than you think and they can be a good advice…

Romain FERRATON
Romain FERRATON
IT Performance Expert
#database#SQL#SQL Server

Many times i was asking for given best practices for T-SQL code but I don't like best practices advices. They can be deprecated faster than you think and they can be a good advice in one case and very bad advise for another case. T-SQL Bad practices on the other hand are more stables. We based our view on T-SQL Code Smells of Phil Factor and organized the 150 T-SQL bad practices with their catagory (database design, table design, data types, expression, query syntax, naming, routines, loopholes) and on what we considered as "more or less important" You can filter on the level of importance (bar) or on a practice represented by a square.

Need help with this topic?

Our team of experts is at your disposal to support you.

Contact us