Benjamin Nevarez Rotating Header Image

About

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 three books, “High Performance SQL Server”, “SQL Server 2014 Query Tuning & Optimization” and “Inside the SQL Server Query Optimizer” and has also coauthored other books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences and events around the world including the PASS Summit, SQL Server Connections and SQLBits. His blog can be found at http://www.benjaminnevarez.com and he can also be reached on twitter at @BenjaminNevarez.

Header image: The “Pillars of Creation” from the Eagle Nebula. Image credit: nasa.gov.

19 Comments

  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!

    Best,

    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.

    Regards,

    Ben

  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

    http://sqlsaturday.com/viewsession.aspx?sat=83&sessionid=4325

    Regards,

    Ben

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

  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.

    Regards,

    Ben

  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, lit.review to end of project

    Please Mention the charges also

    Mail me at:
    engr.saleemmumtaz91@gmail.com

  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 pilugin@inbox.ru
    thanks!!

  9. Benjamin Nevarez says:

    Hi,

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

    Regards,

    Ben

  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.

    Thanks

  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.

    Regards,

    Ben

  12. Jason says:

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

    Regards,

    Ben

  14. Sushant says:

    I am mad the way you are doing your researches…i have completed by engineering last year..now 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.

    Regards,

    Ben

  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.

    Regards,
    Mohammed

  17. Hi Mohammed,

    You can reach me at admin at benjaminnevarez dot com.

    Regards,

    Ben

  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?

    No.2
    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 *