Query Performance Tuning in SQL Server 2014

Overview

Explore query performance tuning in SQL Server 2014 through this informative PASS Data Community Summit preview talk. Dive into a comprehensive optimization checklist covering common problems and essential considerations. Learn about crucial aspects of database design, server configuration settings, and query design. Gain insights into SQL Server configuration for memory, CPU, and storage, as well as effective database administration techniques. Discover best practices for database design, including storage optimization, constraint implementation, and index management. Acquire valuable T-SQL coding tips to enhance query performance. Use this talk as a starting point to address your own SQL Server performance challenges and prepare for a more in-depth exploration of query tuning techniques.

Syllabus

Intro
Technical Assistance
Grant Fritchey
Today's Goal
Goals at Summit
Remember
SQL Server Configuration: Memory
SQL Server Configuration: CPU
SQL Server Configuration: Storage
SQL Server Administration 2
Database Design: Storage
Database Design: Constraints
Database Design: Indexes - General
Database Design: Indexes - Clustered
T-SQL Coding 2
T-SQL Coding 3
T-SQL Coding 4
Relax