Home » performance » Page 3
Statistics update job
· by Hannah Vernon · in maintenance, performance, SQL Server Agent
SQL Server statistics are extremely important for good query performance since they provide invaluable guidelines that allow the query optimizer to pick an optimal plan. Out-of-date or non-existent statistics objects can cause excessive I/O, poor…
Same plans, markedly different performance!
· by Hannah Vernon · in performance
We all know the importance of looking at execution plans when doing performance optimization. However, just because the plan looks good doesn’t necessarily indicate the best outcome. It’s always important to consider the user-experience, and…