Erik Darling
erikdarling.com
Is a combination of House of Pain and Bobby Brown
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.