Benjamin Nevarez

Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning & Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals”. With more than 20 years of experience in relational databases, Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits. Benjamin’s blog can be found at http://www.benjaminnevarez.com and he can also be reached by e-mail at admin at benjaminnevarez dot com and on twitter at @BenjaminNevarez.

http://www.benjaminnevarez.com/ http://feeds.feedburner.com/BenjaminNevarez

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.
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.
This session will show you how the query optimizer has been updated to work with the new SQL Server 2014 features and to provide better performance to existing ones. Topics include Hekaton, the new cardinality estimator and incremental statistics.

Blog posts RSS

SQL Server 2014 Incremental Statistics 25 Feb 2015
Benjamin Nevarez (@BenjaminNevarez) takes a close look at the new incremental statistics feature in SQL Server 2014.

The SQL Server Query Store 19 Feb 2015
Benjamin Nevarez (@BenjaminNeveraz) gives a very early look at a feature coming soon to Azure SQL Database and SQL Server vNext: the Query Store.

SQL Server 2014 Query Tuning & Optimization Book Code 16 Dec 2014
Today I was finally able to finish extracting the code of my new book Microsoft SQL Server 2014 Query Tuning & Optimization after a few readers requested it recently but I had been busy with some traveling in the last few weeks. The book contains a large number of SQL queries, all of which are ...

PASS Summit and Other Speaking Engagements 18 Sep 2014
It is almost that time of the year again when we are all headed to attend the largest SQL Server conference in the world, the PASS Summit, hosted again in Seattle. In my particular case I will also be attending some other SQL Server events where I will be given probably more than a dozen […]

Speaking at SQLBits and the PASS Summit 10 Jul 2014
I am really excited that this weekend I will be flying to the UK to participate in my first European SQL Server conference, SQLBits XII, where I am scheduled to present 2 sessions. SQLBits XII, the largest SQL Server conference in Europe, will be held at The International Centre in Telford, UK from ...