Category Archives: SQLServerPedia Syndication

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

  2. 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 this post but in the comments Jeremy Hughes pointed out …
    Continue reading

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

  4. TSQL Tuesday #59: My Hero, My Inspiration, My Wife

    Leave a comment

    October 14, 2014 by Kenneth Fisher

    TSQL Tuesday is a blog party started by Adam Machanic (b/t) almost 5 years ago. This month Tracey McKibben (b/t) …
    Continue reading

  5. Required reading before upgrading SQL Server.

    3

    October 8, 2014 by Kenneth Fisher

    I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q …
    Continue reading

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

  7. Intro to Auditing in SQL Server on SQL Shack

    Leave a comment

    October 1, 2014 by Kenneth Fisher

    I had an article published yesterday on http://www.SQLShack.com. Intro to Auditing in SQL Server. It’s worth reading if I do …
    Continue reading

  8. Database default locations

    4

    September 29, 2014 by Kenneth Fisher

    One of the options you had when installing your instance was setting some default file locations. Defaut data file location …
    Continue reading

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

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

Follow

Get every new post delivered to your Inbox.

Join 423 other followers