2020 @SQLSatLA presents: Get Your Optimizer to Give up All Secrets by Brian Hansen | @VMware Room
Get Your Optimizer to Give up All Its Secrets by Brian Hansen (@tf3604)
You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details of the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We'll do just that, and then take it a step further with a free unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.
-
55:12
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Agile data preparation with ADF by Sergiy Lunyakin | @VMware Room
14 -
54:43
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Architecting SQL Server on VMware vSphere by Oleg Ulyanov | @VMware Room
36 -
52:38
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Build Your 1M Dollar SQL Practice by Adrian Sullivan | @PureStorage Room
21 -
59:51
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Intelligent Query Processing by Andy Yun | @SentryOne Room
7 -
1:01:57
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA Presents: Google BigQuery ML by Mark Mucchetti | VMware Room (@VMware)
10 -
59:40
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Data Lake Design Patterns by Jason Horner | @Blackline Room
17 -
1:23:35
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: DevOps for Azure SQL by Arvind Shyamsundar | @Microsoft Room
39 -
58:07
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: SQL Server 2019 is not your dad's DBMS by Armando Lacerda | @Blackline Room
18 -
1:03:42
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: SQLServer2019 Top Features for DBAs by Marcelo Adade | @PureStorage Room
12 -
38:26
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Presentation Skills for the Techies by Buck Woody | @Microsoft Room
14