Platinum Sponsor

Benjamin Nevarez

Benjamin Nevarez is a database professional based in Los Angeles, CA, and author of “Inside the SQL Server Query Optimizer”. He has also contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has 20 years of experience with relational databases and has been working with SQL Server since version 6.5. He holds a Master’s Degree in Computer Science and has been a speaker at many SQL Server conferences, including the PASS Summit and SQL Server Connections. Benjamin’s blog is at http://www.benjaminnevarez.com and can be reached by e-mail at admin at benjaminnevarez dot com and on twitter at https://twitter.com/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.

Blog posts RSS

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 ...

New Book: SQL Server 2014 Query Tuning & Optimization 21 Apr 2014
  It looks like my blog has been very quiet for a while once again. Yes, I’ve been busy working on some other SQL Server projects since last year. One of those projects was working on Kalen Delaney’s new book SQL Server 2012 Internals where I co-authored two chapters, “Special Databases” and ...

Speaking at the PASS Summit 2013 09 Oct 2013
In just a few days I will be headed to Charlotte, NC to attend my eleventh PASS Summit. Yes, I’ve been attending this, the largest SQL Server and BI conference in the world, every year since 2003. I am also honored to be speaking at the conference again making this my sixth year as a […]

A Tour of the Hekaton AMR Tool 29 Jul 2013
SQL Server 2014 CTP1 has a tool to help you decide which tables and stored procedures you can move to Hekaton or In-Memory OLTP. In this post I will give you a quick tour of this tool, the AMR (Analysis, Migration and Reporting). The AMR tool is integrated with the Data Collector and to enable ...

Hekaton: Transforming Query Plans into C Code 10 Jul 2013
In-Memory OLTP, code-named Hekaton, is without a doubt the most exciting new feature of SQL Server 2014. We all first learned about this technology when it was announced back at the PASS Summit 2012 conference where it was also mentioned that it will be included in the next major release of SQL ...