Category Archives: Problem Resolution

  1. Creating a connect entry.

    2

    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

  2. Lead Blocker

    5

    January 18, 2017 by Kenneth Fisher

    Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and …
    Continue reading

  3. Why won’t my SQL Logins work?

    9

    January 12, 2017 by Kenneth Fisher

    I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a …
    Continue reading

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

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

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

  7. Pulling data from a non-clustered index

    1

    March 14, 2016 by Kenneth Fisher

    This is one of those things that I found very interesting but figured I’d probably never really use. Of course …
    Continue reading

  8. Start SQL Server without tempdb

    1

    January 20, 2016 by Kenneth Fisher

    tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter. While at …
    Continue reading

  9. ‘Twas 4:45 Friday

    Leave a comment

    December 23, 2015 by Kenneth Fisher

    I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents …
    Continue reading

  10. “That little green arrow.” or “My code used to work but now I’m getting a debug error.”

    3

    October 15, 2015 by Kenneth Fisher

    If you’ve worked with SSMS for any length of time this will look awfully familiar: SSMS 2008R2 SSMS 2012 + …
    Continue reading

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

Join 1,598 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013