About Me

Ben Miller

Ben has been a member of the SQL Server Community for over 17 years now. He is currently working at MaritzCX revolutionizing the SQL Server environment and loving it. He also consults as well. He is a SQL Server MVP and Microsoft Certified Master (MCM) and has spent time in the field using SQL Server since 1997. He has worked at various companies throughout the US as well as at Microsoft for 7 years. He is passionate about SQL Server and automation and integration and uses SMO and PowerShell regularly.

2 Comments. Leave new

Hi Ben,

I was in SqlSaturday241. Your presentation is so terrific and I fully enjoyed it and learned a lot from it. Could you please email me the demoDB? I want to run the scripts to better understand everything you said.

Thank you so much.
Jenny

Reply
Robert Burko
March 31, 2014 08:49

I was at your Be Friendly To Sql Server With TSql Best Practices talk in Madison this weekend. You were talking about implicit data conversions and I asked if there was a script to see where implicit data conversions were taking place in query plan cache. You weren’t aware of any. The guy sitting next to me had just attended Andy Yun’s talk on data types and he told me about this script to find the implicit data conversions in plan cache. Here is it:

http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/08/finding-implicit-column-conversions-in-the-plan-cache.aspx

Reply

Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Menu