Stored Procedure Optimization Techniques

SQL PASS in Detroit (SPID)

Please join us on Thursday, June 14, 2018 for Kimberly Tripp's presentation on stored procedure optimization.  We're meeting at the Pet Supplies Plus corporate headquarters in Livonia near 6-Mile and Newburg, close to I-275.  The address is given below. 
 
<H2 STYLE="background-color: transparent; color: #000000; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 15px; font-style: normal; font-variant: normal; font-weight: bold; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">Stored Procedure Optimization Techniques </H2>
Kimberly will discuss stored procedure caching and the potential for performance problems due to a problem known as parameter sniffing. There are some common solutions and while they can drastically improve performance, they can also cause other problems. Sometimes a hybrid solution is needs, from this session, you’ll know the best way to write procedures so that stable requests are cached and unstable requests are not (giving you the most optimal performance without wasting resources).
 
<H2 STYLE="background-color: transparent; color: #000000; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 15px; font-style: normal; font-variant: normal; font-weight: bold; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">Speaker Bio: Kimberly L. Tripp </H2>
Kimberly’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world; she’s also been a Microsoft SQL Server MVP for over 10 years. She has over 25 years of experience designing and tuning SQL Server solutions with a focus on optimizing procedural code, indexing strategies, statistics, and partitioning. When she's not tuning SQL servers, she's diving and photographing all sorts of underwater critters such as frogfish with her husband, Paul S. Randal.
<TABLE STYLE="border: 0px #bbbbbb; border-image: 100% / 0; text-align: left; color: #000000; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 10px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; vertical-align: top; white-space: normal; cursor: default; orphans: 2; -webkit-text-stroke-width: 0px; background-color: transparent;" BORDER="0">
<TBODY STYLE="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; cursor: default; border-width: 0px; border-color: #bbbbbb; border-style: none;">
<TR STYLE="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; cursor: default; border-width: 0px; border-color: #bbbbbb; border-style: none;">
<TD STYLE="border: #ffffff;">Date/Time</TD>
<TD STYLE="border: #ffffff;">June 14, 2018</TD>
</TR>
<TR STYLE="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; cursor: default; border-width: 0px; border-color: #bbbbbb; border-style: none;">
<TD STYLE="border: #ffffff;"> </TD>
<TD STYLE="border: #ffffff;">6:00 PM to 8:00 PM</TD>
</TR>
<TR STYLE="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; cursor: default; border-width: 0px; border-color: #bbbbbb; border-style: none;">
<TD STYLE="border: #ffffff;"> </TD>
<TD STYLE="border: #ffffff;"> </TD>
</TR>
<TR STYLE="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; cursor: default; border-width: 0px; border-color: #bbbbbb; border-style: none;">
<TD STYLE="border: #ffffff;">Location</TD>
<TD STYLE="border: #ffffff;">Pet Supplies Plus Corporate Headquarters</TD>
</TR>
<TR STYLE="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; cursor: default; border-width: 0px; border-color: #bbbbbb; border-style: none;">
<TD STYLE="border: #ffffff;"> </TD>
<TD STYLE="border: #ffffff;">
17197 N Laurel Park Dr
</TD>
</TR>
<TR STYLE="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; cursor: default; border-width: 0px; border-color: #bbbbbb; border-style: none;">
<TD STYLE="border: #ffffff;"> </TD>
<TD STYLE="border: #ffffff;">
Livonia, MI  48152
</TD>
</TR>
<TR STYLE="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; cursor: default; border-width: 0px; border-color: #bbbbbb; border-style: none;">
<TD STYLE="border: #ffffff;"> </TD>
<TD STYLE="border: #ffffff;"> </TD>
</TR>
<TR STYLE="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; cursor: default; border-width: 0px; border-color: #bbbbbb; border-style: none;">
<TD STYLE="border: #ffffff;"> </TD>
<TD STYLE="border: #ffffff;"> </TD>
</TR>
</TBODY>
</TABLE>

Pet Supplies Plus Corporate Headquarters

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Stored Procedure Optimization Techniques

More events from SQL PASS in Detroit (SPID)

Discover more events from SQL PASS in Detroit (SPID), from Science & Tech to other experiences you might love.

Stored Procedure Optimization Techniques

More events from SQL PASS in Detroit (SPID)

Discover more events from SQL PASS in Detroit (SPID), from Science & Tech to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.