Tag Archives: code language

  1. What is ANSI_NULLS and why will I be glad when it finally goes away?

    Leave a comment

    July 28, 2014 by Kenneth Fisher

    Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and …
    Continue reading

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

  3. Yes, Virginia, you can have too much white space.

    20

    July 16, 2014 by Kenneth Fisher

    When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch …
    Continue reading

  4. What does it mean that a value is NULL?

    9

    July 14, 2014 by Kenneth Fisher

    Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be …
    Continue reading

  5. Dealing with a long string

    4

    June 25, 2014 by Kenneth Fisher

    Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the …
    Continue reading

  6. sp_SrvPermissions & sp_DBPermissions V5.0

    2

    June 23, 2014 by Kenneth Fisher

    These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures …
    Continue reading

  7. 15 years of experience with Identity columns

    25

    June 4, 2014 by Kenneth Fisher

    An identity column is an auto incrementing column An identity column is typically used as a primary key A primary …
    Continue reading

  8. What is the difference between Money and Decimal(19,4)

    6

    June 2, 2014 by Kenneth Fisher

    One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4). …
    Continue reading

  9. DBA Myths: A table with a primary key is not a heap

    4

    May 21, 2014 by Kenneth Fisher

    Typically when you see a heading like this you know the answer is “No” or “False” but in this case …
    Continue reading

  10. Escaping from a runaway Logon trigger

    Leave a comment

    May 19, 2014 by Kenneth Fisher

    Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 300 other followers