SQL Server Science
Technical Articles for the DBA / Developer
Home » stats

Does dm_db_stats_properties track statistics properties for “small” tables?

2019-04-24 · by Hannah Vernon · in statistics

A recent question on dba.stackexchange.com about statistics properties asked the following: dm_db_stats_properties does not keep track of small tables? what is the work around to find the number of records in the table? The question…

ALTER TABLE ALTER COLUMN failed because one or more objects access this column

2018-07-19 · by Hannah Vernon · in Internals, performance

There are a variety of causes for the message shown in the title of this post. Manually creating statistics for a column is one such cause. This post shows how that works, and what you…

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…

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