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…
Tag Archive: SQL Server
Disabling Indexes: Saving Time, Saving Space
One of the things I have to do for customers from time to time is alter data in their database. I don’t especially like doing this, simply because I’m messing with customer data and there is an immense amount of responsibility that comes with that. It’s not that I’m averse to being responsible; it can…
TSQL Tuesday #011: Versions and Editions
“You can’t go back. You have to go forward to go back.” – Gene Wilder in Willy Wonka & the Chocolate Factory This month’s T-SQL Tuesday is hosted by Sankar Reddy ( blog | Twitter ) and the topic is Misconceptions in SQL Server. One misconception I frequently see in the customer base with…
