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…
Category Archives: Customers
Consulting: Who Do You Play For?
Originally written Thursday, March 3, 2011. As I type, I’m flying home from a three day customer site visit, listening to the movie Miracle on my iTouch. My day didn’t end well. Before we left the customer site we had a meeting with a technical representative from another Independent Software Vendor (ISV), and the interaction…
What’s Your SLA?
Today I’m flying out to visit one of our customers for a few days. Usually when I go to a customer site I’m looking at solution performance, but this customer requested that we come on site to review their solution and make Disaster Recovery (DR) recommendations. I love going to customer sites for a variety…
Bulk Logged Recovery Model and Point In Time Recovery
A couple weeks ago I spoke with a customer who was having problems with their index rebuilds after a SQL Server upgrade. The database is about 160 GB and they upgraded from SQL Server 2000 to SQL Server 2005. Since the upgrade, the index rebuilds have been failing because the transaction log is filling up. …
