filmov
tv
Query Tuning Internals for the Advanced SQL Developer|Advanced Query Tuning|Advanced DBCC Commands
Показать описание
Title: Query Tuning Internals for the Advanced SQL Developer ~ Kevin Kline
Follow us on Twitter @CloudDataDriven & Facebook, LinkedIn at #clouddatadriven
Level: 300-400
Abstract:
Skilled SQL developers know that the SQL Server query optimizer uses a multi-step process to produce execution plans. But what about deeper components like the parser, the binder, the algebrizer, as well as the optimizer itself? This session will teach you advanced techniques for query tuning as well as surprising behaviors of the query optimization process that can have a dramatic impact on performance, with special attention paid to the processes controlled by the algebrizer, including associative, commutative, and transitive transformations. We will examine a variety of everyday queries whose performance can be greatly improved by apply a deeper understanding of these internal behaviors. Lots of examples and demos!
• Goal 1: Learn advanced and undocumented methods to see the steps of parsing, binding, algebrizing, and query optimization.
• Goal 2: Explore the SQL Server internal memo structure to see how SQL Server uses the heuristics of the algebrizer and query optimizer.
• Goal 3: Walk through several examples of SQL queries whose behavior can be greatly improved when you apply what you’ve learned about the algebrizer and query optimizer.
Prerequisites: Attendees must know how to write and tune SQL queries, as well as how to read execution plans.
Summary: Learn the hidden internals of query processing and apply those lessons in your SQL applications, diving deep into the algebrizer and optimizer.
Bio: Kevin Kline is a Head Geek, noted database expert and author, and software industry veteran. As a 17-time Microsoft Data Platform MVP and with 35 years' experience under his belt, Kline is passionate about improving the quality of life for Microsoft database professionals, their IT organizations, and their customers. He is the author or co-author of 11 books, include the best seller SQL in a Nutshell.
SQL Server Query Optimizer, Advanced DBCC commands, Advanced Query Tuning
Follow Us On Social Media AT #clouddatadriven
Join Our Social Media User Group
Follow us on Twitter @CloudDataDriven & Facebook, LinkedIn at #clouddatadriven
Level: 300-400
Abstract:
Skilled SQL developers know that the SQL Server query optimizer uses a multi-step process to produce execution plans. But what about deeper components like the parser, the binder, the algebrizer, as well as the optimizer itself? This session will teach you advanced techniques for query tuning as well as surprising behaviors of the query optimization process that can have a dramatic impact on performance, with special attention paid to the processes controlled by the algebrizer, including associative, commutative, and transitive transformations. We will examine a variety of everyday queries whose performance can be greatly improved by apply a deeper understanding of these internal behaviors. Lots of examples and demos!
• Goal 1: Learn advanced and undocumented methods to see the steps of parsing, binding, algebrizing, and query optimization.
• Goal 2: Explore the SQL Server internal memo structure to see how SQL Server uses the heuristics of the algebrizer and query optimizer.
• Goal 3: Walk through several examples of SQL queries whose behavior can be greatly improved when you apply what you’ve learned about the algebrizer and query optimizer.
Prerequisites: Attendees must know how to write and tune SQL queries, as well as how to read execution plans.
Summary: Learn the hidden internals of query processing and apply those lessons in your SQL applications, diving deep into the algebrizer and optimizer.
Bio: Kevin Kline is a Head Geek, noted database expert and author, and software industry veteran. As a 17-time Microsoft Data Platform MVP and with 35 years' experience under his belt, Kline is passionate about improving the quality of life for Microsoft database professionals, their IT organizations, and their customers. He is the author or co-author of 11 books, include the best seller SQL in a Nutshell.
SQL Server Query Optimizer, Advanced DBCC commands, Advanced Query Tuning
Follow Us On Social Media AT #clouddatadriven
Join Our Social Media User Group
1:06:27
1:11:45
0:47:26
1:37:51
1:26:30
0:20:50
0:10:16
1:01:54
0:06:01
0:12:02
1:34:44
0:09:29
0:13:19
1:03:44
0:59:33
1:12:24
0:17:19
0:04:40
0:06:43
1:28:51
1:08:47
0:08:22
0:51:32
0:09:05