Most DBAs and Developers know how indexes work and how to write efficient queries. However, the secrets of efficient indexes and queries are actually hidden in behind-the-scene configurations. When these essential configurations are not set correctly, database application performance goes downhill. SQL Server Optimizer Engine produces many different possibilities and helps build an optimal execution plan for any query.
Join IDERA and Pinal Dave as he walks through three of the most important settings that help SQL Server Optimizer Engine write better execution plans with indexes. This session will not discuss query rewriting or index modification. Instead, Pinal will discuss the secret configurations which are often ignored or overlooked by SQL experts. This session is for everyone who wants to improve the performance of their system without making any code changes.
Pinal Dave is a technology enthusiast and independent consultant with over thirteen years of experience in the information technology sector. He has successfully authored 11 SQL Server database books, 18 Pluralsight courses and written over 3200 articles on database technology via his blog http://blog.sqlauthority.com. Rounding out his professional career, Pinal has held key positions as Sr. Consultant for SolidQ and as a Technology Evangelist for Pluralist and Microsoft. Pinal holds a Master of Science from the University of Southern California, and numerous professional certifications, including MCTS, MCDBA and MCAD (.NET).
Topics: Database Performance Products: DB Optimizer