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.
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
Expert en Performance IT
#database#SQL#SQL Server
Articles similaires

SQL Server23 mars
TPCH SF10 : Query 13 and SQL Server Collations Performance Impact
After benchmarking several cloud databases (Snowflake, BigQuery, SingleStore, Databricks) using TPCH SF10 data, after benchmarking DuckDB and Tableau Hyper on my own machine, I…

SQL Server9 févr.
SQL Server CLR Functions vs SQL 2019 Function Inlining
Booster vos performances SQL Server en utilisant des fonctions compilées CLR C à l'intérieur même de votre SGBDR préféré à la place des fonctions SQL classiques ! Ce tutorial…

SQL Server1 mai
Database Engines Trends Dashboard
Database Engines Trends DashboardDB Engines.com is a website that reference and rank hundreds of database engines, threw the most famous ones likes Oracle, MySQL, SQL Server,…
Besoin d'aide sur ce sujet ?
Notre équipe d'experts est à votre disposition pour vous accompagner.
Contactez-nous