Welcome to the St. Louis SQL Server User Group (STLSSUG)   

Join Our Group Online!

 Receive a $150 discount to the PASS 2014 Summit when you Register with our unique discount code: USNCS35 

Next Meeting




STLSSUG September 9, 2014 Meeting

  • In-Person @ Three City Place Drive, Suite 1100 St. Louis, Missouri, United States (map)
  • 13:00 - 17:00 Central Daylight Time
  • Language: English

St. Louis SQL Server User Group Meeting 

September 9th 1:00 pm- 4:00 pm 

Vendor Presentation 4:15 pm- 5:00 pm 


The next St. Louis SQL Server User Group meeting will be on September 9th from 1:00 pm – 4:00 pm with a vendor presentation from 4:00-5:00pm.    Please RSVP, so that we can have a count for a lunch order, https://www.eventbrite.com/e/stlssug-september-9-2014-meeting-tickets-12491643843 


Also, please feel free to forward this meeting announcement to anyone who may be interested in attending. 


This will also be broadcasted as a lync meeting.  Lync meeting link is listed below 


Location: Microsoft St. Louis Office, Three City Place Drive, Suite 1100, St. Louis, MO  63141.  Parking is in the garage behind / next to the building.  There is an entrance to the building from the 2nd floor in the garage. 



Agenda12:30 – 1:00    Registration - Lunch Provided -  Solarwinds 

1:00                Dean Richards, Solarwinds –  Query Tuning - Get it Right the First Time 


2:30                Dean Richards, Solarwinds –  Introduction to Wait Types and Response Time Analysis 


4:00                 Raffle Drawing –  Apress, Wrox, McGraw-Hill, Murach, Wiley, O'Reilly/MS Publishing Books and more! 


4:15                 Vendor Presentation 


Dean Richards is a Manager of Sales Engineering and has helped hundreds of companies solve database and virtualization performance issues.  Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize databases while still achieving high performance. 

Linked-In: http://www.linkedin.com/deanrichardsignite/ 

Twitter: @ConfioDean 



Title:  Query Tuning - Get it Right the First Time 

Whether you are a developer or DBA, this presentation will outline a method for determining the best approach for tuning a query every time by utilizing response time analysis and SQL Diagramming techniques.  Regardless of the complexity of the statement or database platform being utilized (this method works on all), this quick and systematic approach will lead you down the correct tuning path with no guessing.  If you are a beginner or expert, this approach will save you countless hours tuning a query.




Introduction to Wait Types and Response Time Analysis 

Using Wait Types and Response Time Analysis techniques is a newer and often miused method for tuning SQL Server instances and applications. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the response time data is analyzed at the wrong level and is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server wait type data coupled with response time based performance analysis to solve the most difficult performance related issues.