Category Archives: T-SQL

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

    Leave a comment

    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

  2. What are trace flags?

    Leave a comment

    September 11, 2014 by Kenneth Fisher

    Trace flags are one of those things that I’ve heard about more and more over the last five or six …
    Continue reading

  3. Two simple commands that can be a big help in performance tuning.

    4

    September 2, 2014 by Kenneth Fisher

    The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are …
    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. SchemaBinding – What & Why

    6

    August 6, 2014 by Kenneth Fisher

    What When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying …
    Continue reading

  6. Deny vs Revoke

    1

    August 4, 2014 by Kenneth Fisher

    Quick quiz. Which of these two commands is the opposite of GRANT? DENY REVOKE   Well lets start with some …
    Continue reading

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

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

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

    21

    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

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

    11

    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

Follow

Get every new post delivered to your Inbox.

Join 372 other followers