Anyone who’s frustrated with supporting and performance tuning queries with really long SELECT lists.
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.
Why I Want to Present This Session:
This used to be one of the most frustrating parts of my job, and it’s not something there are always easy answers for.