SQL Server Performance Tuning and Optimization

SQT06 Turbo Boost - SQL Tricks Everybody MUST Know


1:30pm - 2:45pm

Level: Introductory to Intermediate

Pinal Dave

MS Computer Science

SQL Server Performance Tuning Expert

Data and Database is a very important aspect 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. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

You will learn:

  • SQL Server 2014 has introduced quite a few new things with related to SQL configurations. We will cover its impact with examples (memory, SSMS settings, filegrowth)
  • About the concepts of auto-update as well auto-create statistics with a clear example
  • The common tricks of SQL deployments which can immediately improve performance like tempdb , memory and CPU configurations etc.