Natural Born Killers, Performance Issues to Avoid

Learning SQL is easy, mastering it is hard. In this session you’ll learn simple but effective tricks to design your database objects better and write more optimized code. As an attendee you will gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.

Ever thought that you were adhering to best practices but still seeing performance problems? You might
well be. In this session I will be covering why the optimizer isn’t using all available processors, when the database engine fails to report all the resources a query has used and why the optimizer doesn't always use the best plan.

You will leave this session with a list of things that you can check for in your environment to improve
performance for your users.

Presented by Richard Douglas at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Richard_Douglas.jpg
    Richard Douglas is a Systems Consultant and SQL Server Evangelist for Dell Software where he specialises in providing SQL Server solutions and system health checks to organisations across the EMEA region. Richard is the founder and organiser of the Maidenhead SQL Server User Group and has spoken at several PASS events including the PASS Summit, SQL Rally's and SQL Saturdays. Richard also regularly presents webinars for Dell Software and PASS Virtual Chapters on various SQL Server related topics and was a technical reviewer on two SQL Server 2012 books. Richard can be contacted via Twitter @SQLRich or on his blog http://SQL.RichardDouglas.co.uk
    http://sql.RichardDouglas.co.uk
  • Video
    The video is not available to view online.