Rotating Header Image

Posts Tagged ‘statistics’

Do You Even Blog Bro? (Stats, Execution Plans, Indexes, and crazyness)

Have you ever worked with a piece of software for like 15-20 years and ended up doing something with that product that you haven’t or can’t remember doing ever before?   This happened to me quite recently and although I wont have a bunch of sexy scripts for you to reproduce the problem I will […]

List All Statistics For a Column – Update

Msg 5074, Level 16, State 1, Line 1 The statistics ‘StatName’ is dependent on column ‘ColumnName’. Msg 4922, Level 16, State 9, Line 1 ALTER TABLE DROP COLUMN ColumnName failed because one or more objects access this column. So what is a nice quick and easy way to list all the statistics that are dependant […]

Statistics… Peeling Away More Of The Onion

So this post is a continuation of sorts of my last post on Updating Statistics before or after an index rebuild. I asked myself the question “How often should you run statistic maintenance in general? and do I have to run any statistic maintenance if I have auto update stats enabled?” OK I didn’t REALLY […]

Update Statistics Before or After an Index Rebuild?

So a Twitter friend of mine @peschkaj tweeted this morning: “Just finished adding scripts to update stats and rebuild indexes after our nightly and weekly loads. Now on to… something else.” So I asked the question: “now the question is… did you update stats BEFORE or AFTER the index rebuild? :)” He replied with the […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.