This month’s TSQL Tuesday is hosted by Amit Banerjee ( blog | @banerjeeamit ) and topic is TSQL Best Practices. Now, I have never taken a T-SQL class, and I am not a database developer. I have spent minimal time with anyone, one on one, reviewing the “right way” to write T-SQL code. I understand…
Category Archives: Statistics
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…
