San Francisco, California
London, United Kingdom
Free SQL Server Training!
Join us for the March 17, 2015 meeting of the Pinellas SQL User Group. Our meetings are free and open to the public. The doors open at 6:00 pm and food arrives shortly after that allowing time to grab something to eat and networking with your peers. The meeting will start at 6:30 with announcements and open floor discussions followed by the speaker for the night.
Presentation: Dealing with Multipurpose Procs and PSP the RIGHT Way!
Summary: What is parameter sniffing? When does it occur and when does it become a problem (a.k.a. parameter sniffing problem / PSP)? How can you simplify your procedure creation strategies to create procedures that recompile “enough” – not too much or not enough? Wait, isn't recompilation bad? Come to this session to learn when recompilation is warranted. And, more importantly, how to choose to do it selectively and only for the combinations of parameters that really need it. Create the right balance of CPU / recompilation with a programming strategy that also simplifies the overall number of procedures needed. If you create stored procedures and want better performance, this is the place to be!
About Kimberly: Kimberly is the president and founder of SQLSkills.com. She has been a Microsoft SQL Server MVP and a Microsoft Regional Director for over 10 years; she's an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world. She has over 20 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. Email: Kimberly@SQLskills.com Website: http://www.SQLskills.com Full Bio: http://www.sqlskills.com/about/kimberly-l-tripp/ Blog: http://www.SQLskills.com/blogs/Kimberly Twitter: http://twitter.com/KimberlyLTripp SQL Server MVP since 2002
Food and drinks will be provided by
Kforce® (NASDAQ: KFRC) is a professional staffing and solutions firm providing knowledge workers across myriad industries. We provide flexible and permanent staffing solutions in the specialty areas of technology and finance & accounting and health information management. Additional competencies include technology outsourcing solutions and services to federal agencies through subsidiaries.
At Kforce, we believe that Great People = Great Results®. We understand what drives our specialty industries, follow a disciplined process to identify quality candidates, partner with employers to understand their core business and their employment requirements, and achieve great results for all concerned.
Kforce’s 1,600 staffing specialists operate through 60 domestic offices and bring the value of 50 years of experience to your personnel and career development needs.
When & Where
Pinellas SQL User Group
The Pinellas SQL User Group meeting are free and open to the public. The doors open at 6:00 pm and food arrives shortly after that allowing time to grab something to eat and networking with your peers. The meeting will start at 6:30 with announcements and open floor discussions followed by the speaker for the night.