Tag Archives: language sql

  1. A script to list the DTS connection information for every package on the instance.

    Leave a comment

    October 27, 2014 by Kenneth Fisher

    For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the …
    Continue reading

  2. Force only certain values to be unique

    1

    October 22, 2014 by Kenneth Fisher

    I thought of something rather interesting the other day while answering a question asking for help with some table structures. …
    Continue reading

  3. Update to “The clustered index columns are in all of the non clustered indexes.”

    2

    October 20, 2014 by Kenneth Fisher

    I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments …
    Continue reading

  4. UNION vs UNION ALL

    5

    October 16, 2014 by Kenneth Fisher

    You might be wondering why I’m going into such a simple subject. Well the way I see it there are …
    Continue reading

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

  6. Changing configuration settings with sp_configure

    2

    September 22, 2014 by Kenneth Fisher

    I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that …
    Continue reading

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

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

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

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

    5

    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

Follow

Get every new post delivered to your Inbox.

Join 428 other followers