Rob Mandeville
where else to find them
what they talk about
where they keep going back
- SQLBits3 editions2019–2023
on a stage with
never shared a talk
who talks about the same things
- John Morehouse14 talks
- CLÁUDIO SILVA9 talks
- Alexander Arvidsson14 talks
- Kevin Kline13 talks
- Bradley Ball7 talks
- Grant Fritchey19 talks
| title | conference | date |
|---|---|---|
| Should We Defragment Indexes? | SQLBits 2023 | 2023-03-14 |
Argues that external fragmentation can make defragmenting counterproductive: rebuilding or reordering pages often concentrates them onto a single capacity… | ||
| Should We Defragment Indexes? | SQLBits 2022 | 2022-03-08 |
Argues that defragmenting indexes can harm throughput on VM/cloud storage because forcing pages into sequential order concentrates them on a single capacity… | ||
| Stop Indexing the Query | SQLBits 2022 | 2022-03-08 |
Methodology identifies low‑ROI queries by computing logical and physical reads divided by rows desired and reads to rows > 8 filters the worst candidates, then… | ||
| Should We Defragment Indexes? | SQLBits 2019 | 2019-02-27 |
Argues that defragmenting indexes for external fragmentation can hurt throughput on VM/hypervisor storage that uses an SSD cache fronting capacity devices… | ||
| Stop Indexing the Query | SQLBits 2019 | 2019-02-27 |
Methodology scores queries by an inefficiency score = (logical + physical reads) / rows × execution count, then groups statements by table and ranks them… | ||
| nothing matches | ||