Tag Archives: T-SQL

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

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

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

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

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

  9. Why is there a sysobjects when we already have sys.objects?

    Leave a comment

    May 5, 2014 by Kenneth Fisher

    Once upon a time in a version of SQL far far away we had system tables that were easy to …
    Continue reading

  10. DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

    7

    April 30, 2014 by Kenneth Fisher

    Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 300 other followers