Architecture & Performance
SQL Server3 January 20221 min de lectureArticle en anglais

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
Expert en Performance IT
#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.

Besoin d'aide sur ce sujet ?

Notre équipe d'experts est à votre disposition pour vous accompagner.

Contactez-nous