Category Archives: Problem Resolution
-
I’ve gotten a transaction log full error but when I look it’s not full??
2April 16, 2018 by Kenneth Fisher
Every now and again I’ll get an error telling me a transaction log is full. This can be for any …
Continue reading -
Deleting a lot of data
5April 12, 2018 by Kenneth Fisher
I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
Continue reading -
Simply Debugging
3March 7, 2018 by Kenneth Fisher
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it …
Continue reading -
A day in the life of a Sr DBA/Dev
Leave a commentFebruary 28, 2018 by Kenneth Fisher
If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points …
Continue reading -
Help it takes forever to open the SQL Server Log!
Leave a commentJanuary 24, 2018 by Kenneth Fisher
Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the …
Continue reading -
How to read a technical blog
4January 17, 2018 by Kenneth Fisher
There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If …
Continue reading -
A Solution for Squirrely SQL Server Security: TSQL Tuesday #98
Leave a commentJanuary 9, 2018 by Kenneth Fisher
It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject …
Continue reading -
Compressed backup errors and TF 3042
6March 16, 2017 by Kenneth Fisher
Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time …
Continue reading -
Deadlock on ALTER DATABASE
5February 16, 2017 by Kenneth Fisher
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you …
Continue reading -
Deadlock priority
5February 8, 2017 by Kenneth Fisher
Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who …
Continue reading
