Tag Archives: problem resolution

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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

  6. SQL Connectivity issues: A guided walk through

    Leave a comment

    February 6, 2017 by Kenneth Fisher

    The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues. Announcement Walk Through If …
    Continue reading

  7. Creating a connect entry.

    4

    January 23, 2017 by Kenneth Fisher

    I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of …
    Continue reading

  8. sp_refreshsqlmodule_internal – The user does not have permission to perform this action.

    Leave a comment

    December 28, 2016 by Kenneth Fisher

    Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found …
    Continue reading

  9. Altering a column in a large table: A case study

    20

    July 14, 2016 by Kenneth Fisher

    Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to …
    Continue reading

  10. Comparing the contents of two tables Redux

    Leave a comment

    June 8, 2016 by Kenneth Fisher

    I did a post the other day on comparing two tables. It was meant as a general overview but I …
    Continue reading

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

Join 2,163 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013