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
Query Tuning and Optimization
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.
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
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.
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
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
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
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
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!!
Hi,
Thanks for your comments. I’ve just sent you a message to your e-mail address.
Regards,
Ben
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
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
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!
Hi Jason,
Sure, sending you an e-mail right now.
Regards,
Ben
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
Hi Sushant,
I am contacting you by e-mail.
Regards,
Ben
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
Hi Mohammed,
You can reach me at admin at benjaminnevarez dot com.
Regards,
Ben
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
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.