SQL Server Science
Technical Articles for the DBA / Developer
Home » performance » Page 3

Statistics update job

2018-07-10 · 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!

2016-05-24 · 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…

« Previous 1 2 3
subscribe now for updates
Stay up-to-date with the latest posts as they happen!
* = required field
unsubscribe from list

Search

Categories

  • announcements
    • events
  • basics
    • localization
  • configuration
  • DMVs
  • documentation
  • extended-events
  • Internals
  • maintenance
    • patching
  • performance
  • recovery
  • reporting
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
  • troubleshooting
  • Uncategorized

Pages

  • About SQL Server Science
  • Cart
  • Checkout
  • Get Better Help with a Minimal, Complete, and Verifiable Example, or MCVE
  • My account
  • Privacy Policy
  • Shop

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2023 SQL Server Science