Tag Archives: sql statements

  1. You can’t use aggregate/windowing functions with CROSS APPLY

    7

    October 6, 2014 by Kenneth Fisher

    One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well …
    Continue reading

  2. Triggers are not toys!

    8

    September 17, 2014 by Kenneth Fisher

    For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL …
    Continue reading

  3. I SCHEMABOUND my scalar UDF and you won’t believe what happened next.

    1

    September 15, 2014 by Kenneth Fisher

    Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this …
    Continue reading

  4. More than sp_help

    1

    August 14, 2014 by Kenneth Fisher

    If you have worked with SQL Server for very long you have probably run across the extremely useful system function …
    Continue reading

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

    11

    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

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

  7. 15 years of experience with Identity columns

    26

    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. Escaping from a runaway Logon trigger

    1

    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

  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 423 other followers