This is part 3 in a series on shrinking and transaction management. Click here for part 4. You can see them all in the Shrinking & Transactions category.
If you are one of the people who have been reading this blog, you know where I stand on shrinking databases/log files. I don’t like the practice (Post 1, Post [...]
Tag Archives: Pet Peeves
Manage Your Transactions (So they don’t manage you – Part 1)
Just add a join hint!
When I posted about Empirical Evidence and finding a Troubleshooting Methodology, I talked about implementing a solution just because it seemed to work. This can manifest itself in different ways. Some are alright and harmless (what your shotgun hit happened to be the right fix) and some can be dangerous and hide the real problem.
One [...]
Shrinking is a popular topic…
When I started blogging, my first posts were on shrinking. That’s still a popular search. Why?
DBA Questions To Ask A Vendor
A while back a conversation on Jonathan Kehayias’ former blog (he has moved) gave me an idea for this post.
Once you have been a DBA for any length of time, you will encounter the situation of a new vendor coming in with software that has a database back end. Wherever I am working or [...]
Empirical Evidence
Or how I learned to stop asking so much and start trying…
Empirical, as defined by Webster: 1.) originating in or based on observation or experience 2.) relying on experience or observation alone often without due regard for system and theory 3.)capable of being verified or disproved by observation or experiment.
I think empirical thought and evidence [...]
Do you focus too much on your backups???
Have you lost your mind?!
What could I possibly mean by that title? I’m a DBA… One of the basic tenets of a DBA is “backup, backup, backup”, right? Well sort of…
Far too often I hear people asking questions like “will this setup allow our backups to be fast?”, “how is your backup process working?” or [...]
Follow Straight Path
Recent Comments