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.