~/talks

Hugo Kornelis

what they talk about

where they keep going back

on a stage with

who talks about the same things

titleconferencedate
Here’s the execution plan … now what?SQLBits 20242024-03-19
Examines real plans to find the exact culprit: a dashboard paginated_sales_report uses a temp table and a full Sort that requests ~47 MB per execution…
Talk on
Here’s the execution plan … now what?SQLBits 20222022-03-08
Diagnoses a dashboard causing resource semaphore waits by reading actual execution plans and estimated operator input, finds a 120,000-row sort feeding a temp…
Talk on
Parameter Sensitive Plan Optimization in SQL 2022 ... As Cool as it Sounds?SQLBits 20222022-03-08
SQL Server 2022 adds Parameter Sensitive Plan Optimization (PSPO) which, at compat level 160, creates a dispatcher plan plus up to three variants per skewed…
Talk on
Here’s the execution plan … now what?SQLBits 20192019-02-27
Hands-on diagnostics for real plans: shows a dashboard proc causing resource semaphore waits where a 47 MB memory grant 47MB → 14MB drops by splitting the…
Talk on
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.