Benjamin Nevarez is a database professional based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of several books including “High Performance SQL Server”, “SQL Server 2017 on Linux”, “SQL Server 2014 Query Tuning & Optimization” and “Inside the SQL Server Query Optimizer” and has also coauthored other books such as “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences around the world. His blog can be found at http://www.benjaminnevarez.com and he can also be reached on twitter at @BenjaminNevarez and Facebook at https://www.facebook.com/BenjaminNevarez
Benjamin Nevarez's Sessions
Dive into the Query Optimizer-Undocumented InsightSQLBits 2014
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization.
Understanding Parameter SniffingSQLBits 2014
This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well.