Overview
Discover 50 essential SQL Server development tips in this comprehensive conference talk from PASS Data Community Summit. Learn crucial aspects of database design, T-SQL best practices, and query tuning techniques from expert Aaron Bertrand. Explore topics such as choosing appropriate data types, avoiding redundant data, optimizing column usage, understanding heaps, leveraging variable length types, and mastering cursor options. Gain insights into schema prefixing, identifying query performance red flags, and comprehending the query optimizer's behavior. Delve into advanced concepts like coercing the optimizer and managing parameter sniffing to enhance your SQL Server development skills and boost database performance.
Syllabus
Intro
Technical Assistance
PASS SUMMIT 2015
Development Environment
Database Design: Sensible Data Types
Database Design: Redundant Data
Database Design: Column Stuffing
Database Design: Heaps
T-SQL: Variable Length Types
T-SQL: Cursor Options
T-SQL: Schema Prefix
Query Tuning: Red Flags
Query Tuning : Understanding the Optimizer
Query Tuning : Coercing the Optimizer
Query Tuning: Parameter Sniffing
Like What You've Heard?
Taught by
PASS Data Community Summit