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

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…

How can I automate statistics management?

2016-04-14 · by Hannah Vernon · in maintenance, tools

Occasionally, it can be beneficial to turn off AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS, and manage these items yourself. I’ve created the following stored procedure, which lives in master to allow it to be called from the context…

Can statistics be updated for objects in read-only filegroups?

2016-04-14 · by Hannah Vernon · in Internals

DBA.StackExchange.com has an interesting question about the benefits of filegroups and setting filegroups to read-only which I recently answered. I made several assumptions about read-only filegroups that turned out to be incorrect, one of which…

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