The Secret to Getting the Maximum Out of SQL Server Engine
Featuring Guest Speaker - Pinal Dave
Most DBAs understand how indexes work and how to write efficient queries. However, the secret to 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.