Session 1: SQL Server Optimizer: deeper dive!
HTML-код
- Опубликовано: 12 окт 2024
- In this session, we will dive deeper into the sql server optimizer which is responsible for generating execution plans and greatly impact SQL Server performance.
Chapters
0:17 - Query execution workflow
4:15 - Parsing, binding and algebraic tree
5:28 - Optimizer internal steps
5:57 - Simplification
8:10 - Trivial plan
9:07 - Statistics loading
9:50 - Join ordering
12:05 - Stage 0, Stage 1 and Stage 2
12:55 - Useful traceflags to inspect optimizer
13:42 - dm_exec_query_optimizer_info
🧑💼►Follow me on LinkedIn - / bobirmirzo-arslanov-54...
🚀►Github for queries: github.com/Bob...
Watch all my playlists here:
🚀►Full course on Troubleshooting sessions: • Troubleshooting
🚀►Full course on Encrypting connections to SQL Server- • Full course on Encrypt...
🚀 ►SQL Server replication session: • SQL Server replication
🚀 ►SQL Server Always On Availability Group: • SQL Server Always On A...
🚀 ► SQL Server internals: • SQL Internals
🚀 ► Course in On-memory OLTP: • Course on In-Memory OLTP
![BOLIVIA vs. COLOMBIA [1-0] | RESUMEN | ELIMINATORIAS SUDAMERICANAS | FECHA 9](http://i.ytimg.com/vi/zg15uVWjuf4/mqdefault.jpg)
Please increase the voice in these series so that you can hear it more clearly. The voice decreased accidentally while editing.
Hello Arslanov, Thank you for all your sessions. I am learning from them. May you do some videos on Merge Replication and troubleshooting issues. Please
Also I am unable to view all four videos in this crash course. And how to attend the live sessions of yours?
Sure will do.
Currently, I am not doing live sessions. But I have plans for the future
Really appreciate the effort you are putting in, the content and concepts are clearly explained.
But I can barely hear your voice in all of your videos. Tried multiple devices, its same.
Sorry. My voice has accidently been decreased. Have you tried to increase the voice in youtube? if you increase it, you can hear it clearly. I checked.
I cannot replace the video without deleting completely. Sorry about this
@@arslanov1886 No problem, I used an external speaker 🔊 🔊 😂
Thank you for your interest in my videos!
Could you recommend me a book to deeper dive into sql server ?
Sorry. I usually do not use books as they are difficult to understand. Instead I go through MS docs