Benjamin Nevarez Rotating Header Image


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 and he can also be reached on twitter at @BenjaminNevarez and Facebook at


  1. Kevin Boles says:

    Hey Benjamin! I am a SQL Server MVP with a specialization in performance analysis and tuning. I LOVE giving presentations and would like to know if I can have your permission to give your Query Optimizer Topics presentation to various SQL Saturday and SQL Server User Group events. I will not submit to events that you might also attend (but this will be rare anyway since we are on opposite sides of the US). I will also give full credit to you for the material and even include a recommendation that attendees purchase your wonderful Query Optimizer book. Thanks in advance if this is acceptable to you, and no worries if it isn’t!


    Kevin G. Boles
    SQL Server MVP
    Indicium Resources, Inc.

  2. Benjamin Nevarez says:

    Hi Kevin,

    Yes, sure, you can use the material of my Query Optimizer Topics session for your presentations. I am glad you liked it and I hope you like the book too. If possible, please keep me updated on when you are presenting it.



  3. willem merifield says:

    hi ben, busy attending the sqlpass #83. we couldnt finish the presentation via conference; would it be ppossible for you to mail me you presentation along with your sample scripts so i can complete the session. thanks for a very interesting session.

  4. Benjamin Nevarez says:

    Hi Willem,

    Thanks for attending my session. You can download the PowerPoint and script files from this location



  5. David says:

    Hi Ben,
    I am working on Hospital datawarehouse in Australia, i want to improve the performance, so i purchased your book, i love it.
    The issue i have is i can not locate the AdventureWorks sample that you use in the book,
    so i am not getting the same query results and names of objects etc are different that your sample exercises show.
    I do have AdventureWorksDW2008 and AdventureWorksLT2008.
    Could you let me know where i find the database that you are using in your samples.

  6. Benjamin Nevarez says:

    Hi David,

    Thanks for your comment regarding my book. Regarding your question, when you run the sample databases installer you have the choice to install the following six databases

    AdventureWorks OLTP 2008
    AdventureWorks Data Warehouse 2008
    AdventureWorks LT 2008
    AdventureWorks OLTP
    AdventureWorks Data Warehouse
    AdventureWorks LT

    The code on the book uses AdventureWorks OLTP and AdventureWorks Data Warehouse on this list. I hope this answer your question. Feel free to e-mail me at admin at benjaminnevarez dot com if you still have any question.



  7. Saleem says:

    Hello Benjamin Nevarez, I thinks it not right to post here such text. But I’m Ugently looking for a writer who is an M.Sc software engineer, MCA , or M.Sc computer science expert with solid knowledge in the field of database and experience in coding , Query optimization solutions and implementations. I need urgent 30 pages, 7days.. Details will be given.

    =the above is regarding an academic project.

    =i need full project starting from proposal, to end of project

    Please Mention the charges also

    Mail me at:

  8. Hi, Benjamin!
    I’ve read your book – it’s awesome! but I had a few questons, so if you dont mind, i’ll write them if you give me an address, here is mine

  9. Benjamin Nevarez says:


    Thanks for your comments. I’ve just sent you a message to your e-mail address.



  10. Hamid says:

    Hi Benjamin,

    I’ve read (SQL Server 2008 internals)-it’s great! but I had a few questions,so if you dont mind, please five me an address.


  11. Benjamin Nevarez says:

    Hi Hamid,

    Thanks for your message. I am answering your e-mail right now and also sending copy to Kalen Delaney, who is the primary author of the book.



  12. Jason says:

    I have come across your blog and some of your other posts several differnt times doing various research in the past when trying to answer some t-sql questions. You are one of the few people that have posted about using the FAST hint/option. I am trying to deterimine if it can help me for a particular solution as opposed to just a TOP N. Any chance I could pick your brain on the subject with a couple of questions? I would be very appreciative!

  13. Benjamin Nevarez says:

    Hi Jason,

    Sure, sending you an e-mail right now.



  14. Sushant says:

    I am mad the way you are doing your researches…i have completed by engineering last i am interested in doing Database like you do …please guide me how should i approach ? i wana be master in DataBase and BI tools

  15. Benjamin Nevarez says:

    Hi Sushant,

    I am contacting you by e-mail.



  16. Mohammed says:

    Hi Ben,
    I have a few questions on the optimizer. With your permission, could I please get in touch with you as you would be the best person to clear my doubts. Looking forward to hear from you.


  17. Hi Mohammed,

    You can reach me at admin at benjaminnevarez dot com.



  18. Lula says:

    That is very attention-grabbing, You are an excessively professional blogger.

    I’ve joined your feed and sit up for in quest of extra of
    your magnificent post. Also, I’ve shared your site in my
    social networks

  19. taiob says:

    Hi Benjamin,
    Good morning.

    I have 2 requests:
    Number one:
    You gave a talk at Boston(sql saturday 2013) on the above topic.
    I still have some of my notes.
    I noticed you gave a similar talk at PASS 2010.
    Do you know any place I can see the recording of that session from PASS?

    I am going thru my notes and demo code you gave us.
    Under the “03 Computed Columns.sql” you have a piece of code
    SELECT * FROM Sales.SalesOrderDetail
    WHERE OrderQty * UnitPrice > 25000

    — 30% guess
    SELECT 121317 * .3
    — 36395.1 against 5

    ALTER TABLE Sales.SalesOrderDetail
    ADD cc AS OrderQty * UnitPrice

    — does not have to use the computed column name
    — just the expression
    SELECT * FROM Sales.SalesOrderDetail
    WHERE OrderQty * UnitPrice > 25000
    — estimated is now 86.9878
    I cannot figure out how optimizer got the number 86.9878
    Thanks in advance for your help.

Leave a Reply

Your email address will not be published. Required fields are marked *