SQL Server Performance Tuning and Optimization

SQW10 Performance in 60 Seconds - SQL Tricks Everybody MUST Know

12/07/2016

4:00pm - 5:15pm

Level: Intermediate

Pinal Dave

MS Computer Science

Founder

SQLAuthority.com

Your data and database are important aspects of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. You will go over various database tricks that require absolutely no time to master and require practically no SQL coding at all. After attending this session, you'll only need 60 seconds to improve performance of their database server in their implementation. There will be a quiz during the session to keep the conversation alive.

You will learn:

  • About the new things related to SQL configurations in SQL Server 2014
  • About the differences of auto-update and auto-create statistics, and how to use them
  • Common tricks of SQL deployments which can immediately improve performance like tempdb, memory, and CPU configurations