r/SQL • u/javinpaul • Jul 14 '24

SQL Server 17 SQL Query Best Practices for Developers

https://javarevisited.blogspot.com/2024/07/17-sql-query-best-practices-every.html
0 Upvotes

49% Upvoted

6 comments sorted by

24

u/mikeblas Jul 14 '24

Just another shitty list of generalizations. Yawn.

7

u/StolenStutz Jul 14 '24

Do you call them "best practices" when nearly all of them are just rules I'd fail a PR for not following?

6

u/-Dargs Jul 14 '24

Just some self promoting account stating obvious things...

5

u/Noticeably98 Jul 14 '24

No "Select *"

What's the problem here? Maybe tell the database dev to stop making 60 columns per table

1

u/CrazyHG- Jul 15 '24

Like a normalised database would be a good idea to do your reports against. Your performance would rock!!!!

2

u/[deleted] Jul 15 '24

sqlfluff lint