Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Neutralize Troublesome SQL Server Indexes - Fun Stories & Demos

PASS Data Community Summit via YouTube

Overview

This course aims to help learners identify and resolve problematic SQL Server indexes that can hinder server performance. By exploring troublesome scenarios and their workarounds, participants will gain insights into improving query performance by optimizing indexing strategies. The course covers topics such as identifying slow-running queries, understanding the impact of indexes on performance, and implementing indexing tricks to enhance system efficiency. Through practical demonstrations and scripts, developers will acquire the skills needed to address index-related issues effectively. The intended audience for this course includes SQL Server developers and database administrators seeking to optimize server performance through efficient index management.

Syllabus

Introduction
Welcome
Session Title
Agenda
Disclaimer
SQL Server Management Studio
First Demo
Execution Plan
Auto Update Statistics
Auto Update Old Statistics
Why Statistics are Important
How Many Indexes
Why 10DB
Index Consumption
Execution Plan Demo
Walk Table Analysis
Update Statistics
Second Index
SQL Server Optimization
Second Try Index
Second Try Index Demo

Taught by

PASS Data Community Summit

Reviews

Start your review of Neutralize Troublesome SQL Server Indexes - Fun Stories & Demos

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.