Category Archives: Settings

  1. What is the database property “Compatibility Level”

    2

    July 8, 2015 by Kenneth Fisher

    What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in …
    Continue reading

  2. Adding a new keyboard shortcut in SSMS.

    4

    July 6, 2015 by Kenneth Fisher

    I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse. …
    Continue reading

  3. Yet one more quick and easy performance tuning setting

    1

    June 1, 2015 by Kenneth Fisher

    I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS …
    Continue reading

  4. Multiple Windows Groups with different default databases

    2

    May 28, 2015 by Kenneth Fisher

    A question came up at work the other day, mostly as a mind game, but you never know it might …
    Continue reading

  5. Default database

    1

    May 26, 2015 by Kenneth Fisher

    What? The default database is one of the options when creating a login in SQL Server. This is the initial …
    Continue reading

  6. Port numbers and SQL Server

    Leave a comment

    March 30, 2015 by Kenneth Fisher

    I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are …
    Continue reading

  7. Why not NOLOCK?

    5

    March 18, 2015 by Kenneth Fisher

    Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at …
    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

    5

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

Follow

Get every new post delivered to your Inbox.

Join 798 other followers