Category Archives: Settings
-
Yet one more quick and easy performance tuning setting
Leave a commentJune 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
Leave a commentMay 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?
4March 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
4September 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 -
Pausing an MSSQL Instance
10September 4, 2014 by Kenneth Fisher
I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop …
Continue reading -
Default nullability of a new column
Leave a commentMarch 31, 2014 by Kenneth Fisher
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs? …
Continue reading
