Database and Analytics

TH02 Performance in 60 Seconds - SQL Tricks Everybody MUST Know


8:00am - 9:15am

Level: Intermediate

Pinal Dave

SQL Server Performance Tuning Expert

Data and databases are an 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 developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. You'll learn about various database tricks which 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 your database server in their implementation. A quiz during the session will help keep the conversation alive. You'll walk out with scripts and knowledge you can apply to your servers right after the session.

You will learn:

  • About the new things related to SQL configurations (like memory, SSMS settings, filegrowth)
  • About the differences between auto-update as well auto-create
  • The common tricks of SQL deployments which can immediately improve performance like tempdb, memory, CPU configurations, and settings like filegrowth, multiple files which impact performance