50 Things All SQL Server Developers Need to Know
summary
Covers fifty concrete tips across dev environment, schema design, T‑SQL and tuning including how to create a stats-only database to get realistic plans, how to use DBCC OPTIMIZER WHAT IF and DBCC SET WEIGHTS to simulate hardware, why declare varchar without length silently truncates, how adding LOCAL FAST_FORWARD to a cursor drops runtime from ~15.5s to ~5.5s, why spelling out datepart names and schema prefixes prevents subtle plan, collation and cache bugs.
AI-written summary · about
chapters (16)
- 0:00Intro
- 0:47Technical Assistance
- 1:43PASS SUMMIT 2015
- 4:16Development Environment
- 13:47Database Design: Sensible Data Types
- 17:24Database Design: Redundant Data
- 18:17Database Design: Column Stuffing
- 18:56Database Design: Heaps
- 20:39T-SQL: Variable Length Types
- 21:15T-SQL: Cursor Options
- 24:32T-SQL: Schema Prefix
- 41:10Query Tuning: Red Flags
- 43:52Query Tuning : Understanding the Optimizer
- 44:57Query Tuning : Coercing the Optimizer
- 46:46Query Tuning: Parameter Sniffing
- 58:22Like What You've Heard?
related talks
39m10 Things Developers should know about Databases
09mInterview Speaker
26mI’m It – Survival Techniques for the Lone DBA
33mTips and tricks for SQL Developer and SQL Developer command line
18mHow to write powerful SQL that's easy to maintain
33mTips and tricks for the Oracle Database developer
05m10 Things Junior C++ Devs Don't Get
48mThe DB tamer