InfoTechTarget and Informa Tech's Digital Businesses Combine.

Together, we power an unparalleled network of 220+ online properties covering 10,000+ granular topics, serving an audience of 50+ million professionals with original, objective content from trusted sources. We help you gain critical insights and make more informed decisions across your business priorities.

How to Think Like the Engine: Bigger Data Edition

Presented by

Brent Ozar, Founder/Owner Brent Ozar Unlimited, Anthony Nocentino, Senior Principal Field Solutions Architect, Pure Storage

About this talk

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
Pure Storage

Pure Storage

28855 subscribers269 talks
Pure Storage
Pure Storage (NYSE: PSTG) accelerates possible, transforming businesses in ways previously unimagined. The company's disruptive, software-driven storage technology combined with a customer-friendly business model drives business and IT transformation for customers through dramatic increases in performance and efficiency at lower costs. Visit www.purestorage.com to learn more.
Related topics