I got an email from one of my developers regarding a process they had developed in-house. The process has been taking longer and longer to run and it had reached the point where the application was timing out while waiting for a response from the database. Some investigating revealed that the process was timing out […]
I submitted a script to SQLServerCentral.com and it’s been published today. The script automatically re-trusts foreign keys or constraints. It will also report any that could not be re-trusted. Discussion about the script can be found here. I have post here about how your foreign keys and constraints might become untrusted and why it is […]
I think most DBAs by now know that heaps, tables without a clustered index, are bad and should be avoided, but the word hasn’t seemed to have trickled down to software developers yet. I still come across to many vendor databases that contain hundreds, if not thousands, of heaps. In fact, what prompted me to […]
Recently, I was going through all my servers and performing some basic health checks. One of these checks was to look for foreign keys and constraints that are not trusted. I figured this would be something of a rare occurrence and was completely surprised when I found out that roughly 75% of my servers had […]
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 […]