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.
-
1:02:40
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Get Your Optimizer to Give up All Secrets by Brian Hansen | @VMware Room
4 -
59:51
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Intelligent Query Processing by Andy Yun | @SentryOne Room
7 -
12:03
tomerbd
1 year agoOptimization
2 -
0:51
xilly
11 months agoADVANCED PC OPTIMIZATION
3 -
0:57
Pro Trainer Live
1 year agoImprove Your Overall Performance
6 -
11:02
Pharos Technology
11 months agoUnderstanding SQL Fundamentals in Microsoft Access
4 -
12:47
Pharos Technology
4 years agoReduce Data Access Time Through Efficient Query Processing
-
17:05
itmadesimple
11 months agoMaster SQL Aggregate Functions: Beginner's Guide
14 -
0:20
Billy Kasis Digital Marketing
8 months agoHow to optimaze my Search Engine Optimization
12 -
17:00
hayksimonyanrumble
3 months agoThe Complete SQL Tutorial: From Basics to Scaling Databases
2