Skip to Content
54:44 웨비나

How to Think Like the Engine: Bigger Data Edition

This session is for DBAs and developers who are comfortable writing queries, but not as comfortable when it comes to explaining nonclustered indexes, PAGEIOLATCH waits, and physical reads. We’ill also cover the role of storage in optimizing SQL Server operations.
This webinar first aired on 2024년 10월 3일 (목)
The first 5 minute(s) of our recorded Webinars are open; however, if you are enjoying them, we’ll ask for a little information to finish watching.
  • FlashStack
  • 엔터프라이즈 애플리케이션
  • Tech Talks
  • Microsoft SQL & Exchange 솔루션
  • FlashArray//X
  • FlashArray//C
  • FlashArray//E
  • FlashBlade//S
  • FlashBlade//E
  • FlashArray//XL
  • 모던 애널리틱스
  • FlashBlade
  • 데이터 분석
  • 데이터 웨어하우스
  • Microsoft 솔루션

Brent Ozar

Founder/Owner, Brent Ozar Unlimited

Anthony Nocentino

Senior Principal Field Solutions Architect, Pure Storage

When you pass in a query, how does SQL Server build the results? Let’s say Brent Ozar is an end user sending queries, and you'll act as the SQL Server engine. Using simple spreadsheets as your tables, you'll learn how SQL Server builds execution plans, uses indexes, reads data from storage, and caches it in memory. 

This session is for DBAs and developers who are comfortable writing queries, but not as comfortable when it comes to explaining nonclustered indexes, PAGEIOLATCH waits, and physical reads. We’ill also cover the role of storage in optimizing SQL Server operations. 

In this TechTalk, you’ll:

  • Learn how SQL Server builds execution plans, which are critical for understanding how a query will be executed.
  • Gain clarity on indexes and how SQL Server reads data from storage and caches it in memory.
  • Explore the importance of storage in optimizing SQL Server operations, highlighting the impact of storage on query performance.
Continue Watching
We hope you found this preview valuable. To continue watching this video please provide your information below.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
지원하지 않는 브라우저입니다.

오래된 브라우저는 보안상 위험을 초래할 수 있습니다. 최상의 경험을 위해서는 다음과 같은 최신 브라우저로 업데이트하세요.