Category Archives: Problem Resolution

  1. I’ve gotten a transaction log full error but when I look it’s not full??

    2

    April 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

  2. Deleting a lot of data

    5

    April 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

  3. Simply Debugging

    3

    March 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

  4. A day in the life of a Sr DBA/Dev

    Leave a comment

    February 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

  5. Help it takes forever to open the SQL Server Log!

    Leave a comment

    January 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

  6. How to read a technical blog

    4

    January 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

  7. A Solution for Squirrely SQL Server Security: TSQL Tuesday #98

    Leave a comment

    January 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

  8. Compressed backup errors and TF 3042

    6

    March 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

  9. Deadlock on ALTER DATABASE

    5

    February 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

  10. Deadlock priority

    5

    February 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,176 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013