When SQL Server Best Practices Don’t Work
summary
Covers SQL Server best practices and shows concrete cases where following common recommendations blindly harms performance. Examines specific SQL Server features and configurations to explain why a standard Best Practice can worsen server behavior, and when alternative or non-recommended solutions actually perform better.
AI-written summary · about
chapters (7)
- 0:00SQL anti best practices
- 1:37Normalization harm
- 15:31Clustered index vs heap
- 29:33Data type traps
- 41:53Parallelism tuning pitfalls
- 52:45Max degree parallelism overdoing
- 59:42Best practices backfire
related talks
43mQuery Optimization: Don’t Know What to Do? Do What You Know
49mSQL Server Query Execution: Expectation vs Reality
45mBest Practices for Optimizing Database Projects
57mSQL Server hates you(?) - what the DBAs never told the developers
01h 05mHow to Get the Best Out of Your SQL Server on Azure
05mAfter analyzing 600,000 SQL queries, these are the top mistakes developers make
25mThe Secret Life of SQL: How to Optimize Database Performance
40mSQL vs Prejudice