SQL Server Performance Tuning and Optimization

SQH02 Performance in 60 Seconds: SQL Tricks Everybody MUST Know


8:00am - 9:15am

Level: Intermediate

Pinal Dave

SQL Server Performance Tuning Expert


Data and database is a critical 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'll go over various database tricks that 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 the performance of their database server. We'll 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 after the session.

You will learn:

  • Performance tuning
  • Troubleshooting performance
  • Understanding behind the scenes of performance tuning