Category Archives: Settings
-
What is the database property “Compatibility Level”
2July 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 -
Adding a new keyboard shortcut in SSMS.
4July 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 -
Yet one more quick and easy performance tuning setting
1June 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 -
Multiple Windows Groups with different default databases
2May 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 -
Default database
1May 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 -
Port numbers and SQL Server
Leave a commentMarch 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 -
Why not NOLOCK?
5March 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 -
Database default locations
4September 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 -
Changing configuration settings with sp_configure
5September 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 -
What are trace flags?
Leave a commentSeptember 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
