Tag Archives: microsoft sql server

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

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

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

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

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

  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. T-SQL Tuesday #58: Passwords

    2

    September 9, 2014 by Kenneth Fisher

    It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 423 other followers