Monthly Meetings

Our regular monthly meetings occur on the last Friday of each month from 11:30 AM - 1:00 PM. Lunch is served during the first half hour and the scheduled session begins at noon. We meet at The Microsoft Heartland Office which is located at

The Microsoft Heartland Office
8 City Blvd, Suite 403
Nashville, TN 37209
Phone: (615) 778-2500
Fax: (615) 778-2510      

For the month of July, 2016, we will be meeting in a special place, Nashville Software School.

Next Meeting: Thu, Jul 28 2016

July Meeting: SQL Vacation with Kevin Kline: Four Ways We Kill the SQL Server Plan Cache

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.com/e/july-meeting-nash-ssug-kevin-kline-at-nss-tickets-26724843727


Four Ways We Kill the SQL Server Plan Cache

Level: 200

SQL Server’s plan cache is one of the largest regions of memory and is used to store all SQL queries and T-SQL code for quick execution. It is largely self-maintaining and self-tuning. However, the kind of queries you write and the way you invoke those queries can have an enormous impact on how the plan cache is maintained, tuned, and optimized. If you don’t do things right, you could end up shooting yourself in the foot and making performance much worse. Attend this demo-loaded session to learn about 4 harmful anti-patterns that developers frequently use without knowing their drawbacks.  

This session will answer questions like:

- What’s currently in the plan cache?

- How often is the code in my plan cache being reused?

- Where are the big opportunities to save space in the plan cache?

- What coding techniques are most likely to make my object recompile unnecessarily or cause SQL Server to cache inefficient query plans? 

There are a short list of mistakes that, if you know of them in advance, will make your life as a database developer much easier. Learn to avoid these four harmful anti-patterns which can slow down the plan cache. Learn how see what is in your SQL Server’s plan cache and how it is behaving. And embrace these recommended techniques to repair poorly performing queries or entirely avoid them in the first place.

Prerequisites: Basic understanding of SQL Server architecture and tools, basic SQL query knowledge.

Kevin Kline is a technology evangelist at SQL Sentry, an award-winning database tools provider. Kevin is a longtime Microsoft SQL Server MVP, is a founder and former president of PASS and the author of many books such as 'SQL in a Nutshell'. Kline tweets at @kekline and blogs at http://blogs.sqlsentry.com/KevinKline.

Sponsored by:

Robert Half

Founded in 1948, Robert Half International (NYSE: RHI) is the world’s first and largest specialized staffing firm. With more than 360 locations worldwide, Robert Half is dedicated to providing you highly skilled professionals whose skills are well-matched to your unique hiring requirements and workplace environment.

Robert Half has built a stellar reputation for high ethical standards, a specialized focus and unparalleled service. As one of the only truly global specialized staffing firms focusing exclusively in professional positions, Robert Half continues to help businesses worldwide find the skills they need, while assisting untold numbers of job seekers in finding meaningful employment.

For more than 15 years, Robert Half has been named to FORTUNE® magazine’s list of “Most Admired Companies.”

Location:

Nashville Software School

500 Interstate Blvd S, Suite 300

Nashville, TN 37210

The location is just off of Nolensville Pike, between I-40 and I-440. 

When
Where
500 Interstate Blvd S, Suite 300 Nashville, TN 37210

When

iCal
UTC : Thu, Jul 28 2016 22:30 - 00:00
Event Time : Thu, Jul 28 2016 17:30 - 19:00 Central Daylight Time
Your Local Time: Thu, Jul 28 2016 22:30 - 00:00

Where

500 Interstate Blvd S
Nashville, Tennessee

Direction: The location is just off of Nolensville Pike, between I-40 and I-440.

Featured Presentation

Four Ways We Kill the SQL Server Plan Cache

Speaker: Kevin Kline, Technology Evangelist SQL Sentry

Summary: Level: 200 SQL Server’s plan cache is one of the largest regions of memory and is used to store all SQL queries and T-SQL code for quick execution. It is largely self-maintaining and self-tuning. However, the kind of queries you write and the way you invoke those queries can have an enormous impact on how the plan cache is maintained, tuned, and optimized. If you don’t do things right, you could end up shooting yourself in the foot and making performance much worse. Attend this demo-loaded session to learn about 4 harmful anti-patterns that developers frequently use without knowing their drawbacks. This session will answer questions like: - What’s currently in the plan cache? - How often is the code in my plan cache being reused? - Where are the big opportunities to save space in the plan cache? - What coding techniques are most likely to make my object recompile unnecessarily or cause SQL Server to cache inefficient query plans? There are a short list of mistakes that, if you know of them in advance, will make your life as a database developer much easier. Learn to avoid these four harmful anti-patterns which can slow down the plan cache. Learn how see what is in your SQL Server’s plan cache and how it is behaving. And embrace these recommended techniques to repair poorly performing queries or entirely avoid them in the first place. Prerequisites: Basic understanding of SQL Server architecture and tools, basic SQL query knowledge.

About Kevin: Kevin Kline is a database expert and Technology Evangelist at SQL Sentry, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of many books, blogger, columnist, and popular international speaker. Kevin's best known book is the best-selling "SQL in a Nutshell" and contributes monthly for Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/KevinKline.

Attachments

 

Exclusive Offers for User Group Members

Oreilly Book Discounts

 Thanks to Oreilly for providing us books to give away and providing a discount code for our users. Buy ebooks at 50% off and print books at 40% off: When you purchase a book or ebook on oreilly.com use the UG Program discount code: DSUG

 

Great Microsoft Learning Offers

Microsoft Learning has released a collection of valuable offers for the PASS user group community. Get the Microsoft Learning products that you want for less. Take advantage today of these special offers for home and office users, IT professionals, and developers by visiting: www.microsoft.com/learning/offers

 

Carry all your tech books with you anytime with one-click reference on Microsoft technologies

Microsoft Press has developed a virtual library for IT Professionals, developers and information workers who want to learn about Microsoft products and related technologies. And we want to share it with the Microsoft user group members. To learn more about the E-Reference Library, please click here (http://www.microsoft.com/learning/books/ereference/default.mspx).

Nashville SQL Server Users Group