Next Meeting

Thursday,

May

11

PASSDC Monthly Meeting

  • In-Person @ The Motley Fool - 2000 Duke Street Alexandria, Virginia, United States (map)
  • 18:30 - 21:00 Eastern Daylight Time
  • Language: English

Our regular meeting, with food provided and a raffle, followed by Office Hours at Clyde's of Chevy Chase across the street (downstairs bar). Bring your questions and build your network of SQL Server peers.

Featured Presentation:

Statistics & Cardinality – How They Work to Find Data Efficiently

Chris Bell, Founder / Lead SQL Consultant WaterOx Consulting

Are your statistics up to date? Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that? In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact from a simple upgrade of your SQL Server to 2014 and using the new cardinality estimator.

About Chris:
Chris offers a unique view of how we live and work with data both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do 'Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the CEO and Lead Consultant for his company, WaterOx Consulting, while remaining the lead DBA at The Motley Fool. You can keep up with Chris' thoughts and technical community activities at WaterOxConsulting.com.

Regular Meeting Details

PASSDC meets the second Thursday of each month at the Microsoft office in Chevy Chase. Meetings begin at 6:30pm, and typically last around two hours.

Location

Microsoft Technology Center
5404 Wisconsin Ave. Ste. 700
Chevy Chase, MD 20815
 

Travel

Metro is your friend; the Microsoft office is located above the Friendship Heights Station on the Red Line.

 

RSVP

 

 

PASSChapterLogo.jpg


Major Sponsors



Capital Personal Computer User Group ( C P C U G )


WaterOx Consulting


sql_micro_sm.gif


GEICO


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