Featuring Guest Speaker - Pinal Dave

pinaldaveLearn how to operate your SQL Server Engine to produce the most efficient execution plan.

Most DBAs understand how indexes work and how to write efficient queries.However, the secret to efficient indexes and queries is 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.