Data Performance Challenges to Avoid

Thought that you were adhering to best practices, but still encountering performance problems?

Learning about SQL Server is easy; mastering it is hard. In this session, Richard Douglas teaches you simple but effective tricks to better design your database objects and write optimized code.

What you’ll learn:

• A deeper understanding of common database development and administration mistakes
  
  
• How you can avoid these common mistakes
  
  
• Why the SQL Server query optimizer isn’t using all available processors
  
  
• When the database engine fails to report all the resources a query has used
  
  
• Why the optimizer doesn’t always use the best plan

After watching this session, you will have a list of things that you can check for within your SQL Server environment to improve data performance.