~/talks

Milos Radivojevic

what they talk about

where they keep going back

on a stage with

never shared a talk

who talks about the same things

titleconferencedate
When to stop tuning a querySQLBits 20242024-03-19
A single T‑SQL query against 100M/335M rows is tuned stepwise: forcing a nested loop join cuts elapsed time from ~11s to ~2s but exposes a 10 GB memory grant…
Talk on
Dealing with Very Large Tables in SQL ServerSQLBits 20242024-03-19
Shows a real 20 billion–row / 4.6 TB table that takes 28 minutes and ~72 million logical reads to return 3 rows when missing an index, so adding indexes must…
Talk on
Dealing with Very Large Tables in SQL ServerSQLBits 20222022-03-08
Practical runbook for tables >1TB with concrete numbers and fixes: an unindexed filter on 20 billion rows, 4.6 TB, 28 minutes, 72M logical reads shows why…
Talk on
When to stop tuning a querySQLBits 20222022-03-08
Single T‑SQL query against Orders (100M) and OrderDetails (335M) returns 248 rows but starts as a hash join with a cluster scan, cold cache costing 5 million…
Talk on
Dealing with Very Large Tables in SQL ServerSQLBits 20192019-02-27
Very large tables (10M–20B rows, multi‑TB) turn small mistakes into huge costs: an unindexed 20B‑row, 4.6TB table returns 3 rows with a 28‑minute, 72M…
Talk on
When to stop tuning a querySQLBits 20192019-02-27
A single T‑SQL query against two tables — 100 million rows in orders and 335 million rows in order_details — starts with a hash join, ~11s and 5 million…
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.