This week I’m on vacation with my family in sunny Orlando. As luck would have it, the SQLSaturday powers-that-be scheduled SQLSaturday #85 here in Orlando this weekend. I submitted a few sessions and had one selected! If you want to learn about statistics, I would love to see you at my session, “You’re My Density:…
Tag Archive: Statistics
Meme Monday: I got 99 problems but a disk ain’t one
Last month Thomas LaRock ( blog | @SQLRockstar ) started a series called Meme Monday, and this week the task is to list nine things that can wrong with SQL Server that are not the result of an issue with the database file storage. Note: The emphasis on nine reminds me of a quote from…
Finding User Created Statistics
Every so often we hear from a customer who gets a variation of this message when trying to upgrade their database to a newer version of our application: Msg 5074, Level 16, State 1, Line 1 The statistics ‘my_stats’ is dependent on column ‘column1’. Msg 4922, Level 16, State 9, Line 1 ALTER TABLE ALTER…
