Tag Archives: problem resolution

  1. Dealing with layered function calls

    4

    February 5, 2015 by Kenneth Fisher

    T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are …
    Continue reading

  2. Finding the reason for the error “Subquery returned more than 1 value”

    1

    January 7, 2015 by Kenneth Fisher

    First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In …
    Continue reading

  3. ‘Twas 4:45 Friday

    2

    December 16, 2014 by Kenneth Fisher

    ‘Twas 4:45 Friday, and all through the office not a creature was stirring, not even the bosses. The code was …
    Continue reading

  4. The amazing never shrinking heap

    Leave a comment

    August 25, 2014 by Kenneth Fisher

    This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However …
    Continue reading

  5. Why am I getting a primary/unique key violation?

    3

    July 23, 2014 by Kenneth Fisher

    This may seem like a question with a simple answer but there is a bit more to it than you …
    Continue reading

  6. db_ddladmin and the SSMS table designer

    Leave a comment

    July 10, 2014 by Kenneth Fisher

    If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
    Continue reading

  7. T-SQL Tuesday #56: Assumptions

    6

    July 8, 2014 by Kenneth Fisher

    I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can …
    Continue reading

  8. Who has the DAC open?

    Leave a comment

    May 28, 2014 by Kenneth Fisher

    The other day I started seeing the following error in my SQL log. Error: 17810, Severity: 20, State: 2. Could …
    Continue reading

  9. Start with stupid

    1

    March 17, 2014 by Kenneth Fisher

    True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked …
    Continue reading

  10. Check your SQL Agent history settings before it’s too late!

    3

    February 10, 2014 by Kenneth Fisher

    A little while back I was doing some research into a failed job and ran into a slight problem. The …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 651 other followers