I wrote almost a year ago about an issue I ran into with Dynamics / Great Plains. The program intentionally tries to select a non-existent column from various tables as a means to determine if the table exists. Back in the days of SQL 6.5, when the Great Plains code was written, a “table / […]
I don’t spend a lot of my time tuning queries. Many of the databases in my company are used by third party products and we have limited control over the changes we can make to those. However, we do have several databases that are used by home-grown applications and these we have much more latitude […]
Pop Quiz, hotshot. A vendor installed a maintenance plan on one of your SQL Servers. It looks like this: What do you do?
The database design for Dynamics / Great Plains is well known to be incredibly poor. Now I’ve run into another reason why the program sucks. As per best practices, I’ve got alerts set up on all my SQL Servers. One of these alerts is for severity 20 errors. I have a server that is host […]
Everyone DBA probably has one database that just gives them fits. It seems there’s always at least one problem database that causes headaches whenever you try to do anything to it. I have one of those. It’s an 800 GB database on one of my SQL 2005 servers. The size itself isn’t what’s driving me […]