22-25 April 2026 
SQLBits 2018
Improving SELECT * Query Performance
For anyone frustrated by column-hoarding users and developers
You’re a DBA or Developer, and you have a gut feeling that these simple queries with an egregious number of columns in the SELECT list are dragging your server down.
You’re not quite sure why, or how to index for them. Worst of all, no one seems to be okay with you returning fewer columns.
In this session, you’ll learn why and when queries like this are a problem, your indexing options, and even query tuning methods to make them much faster.
You’re not quite sure why, or how to index for them. Worst of all, no one seems to be okay with you returning fewer columns.
In this session, you’ll learn why and when queries like this are a problem, your indexing options, and even query tuning methods to make them much faster.
Speakers
Erik Darling's previous sessions
The SQL Server Performance Tasting Menu
Delicious Demos For Doubting Developers
What Else Can Indexes Do?
No pictures of phone books, here. We're gonna look at the way indexes change query behavior for better... and worse.
Improving SELECT * Query Performance
For anyone frustrated by column-hoarding users and developers