The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

CONVERT_IMPLICIT is a hidden danger

Wed, Jun 22 2016 12:00 Eastern Daylight Time

RSVP: https://attendee.gotowebinar.com/register/2524758348730625537

CONVERT_IMPLICIT is a hidden danger

The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.


Alex Grinberg

Alex Grinberg is a certified MS SQL Server professional and has more than 20 years IT experience. He provides SQL Server tuning, optimization, analysis, development, and administration services: creating new applications, converting legacy technologies (SQL Server, VB.NET and C#) and on-site training. Alex is a senior DBA at Cox Automotive. He is a member of the Board of Directors for PSSUG (Philadelphia). Alex also frequently attends and presents at SQLSaturday events around the country, sharing his passion for all things SQL Server. Alex is a guest author for SQLServerCentral.com and also a technical reviewer for Apress.

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley, dbavolunteer@sqlpass.org.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, dbavolunteer@sqlpass.org if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley, dbavolunteer@sqlpass.org.

 

Meeting Recordings

The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Chapter holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.

 

Follow us on Twitter: @PASS_DBA_VC

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids