Abstract
TSQL is one of the most valuable tools any SQL Server professional can add to their tool-set. More aptly, TSQL is a whole chest of tools for the SQL Server professional. One of the most important tools in that TSQL chest is a good understanding of the SELECT statement.
When was the last time you sat down to evaluate a SELECT statement? What actually goes into the processing of that teeny little word? There might be a fair bit more to this simple term than just fetching data from the database. This session covers the simplicity of the select. Then we take it a step further to dive into some of the complexities tied directly to this particular statement.
This session will help the attendee better understand the Select statement. With a more solid understanding of this statement, the attendee can return and implement some of this new knowledge to help improve processing and query response times in their own environments.