One column in sys.database_scoped_configurations finds every setting that differs from its default. I show how to use it, and where it goes blind.
Interview Question of the Week #006 – Is Shrinking Database Good or Bad?
Decide whether shrinking database good or bad advice fits your case, inspect fragmentation, and use low-priority shrink cautiously.
SQL SERVER – Year 2014 Reflections by Tim Radney – Notes from the Field #060
Instead of New Year’s resolutions, Tim Radney suggests looking back. Here are his Year 2014 reflections, a great way to plan the year ahead.
SQL SERVER – Keeping MSDB System Database Lean and Fit – Notes from the Field #033
The MSDB database is one of the most ignored on any server. Tim shares his tricks to keep the MSDB system database lean, fit and at its best settings.
SQL SERVER – SQL Server High Availability Options – Notes from the Field #032
Not sure which of the High Availability options fits your organization? Tim Radney explains the SQL Server choices in very simple words.
SQL SERVER – Finding Jobs Shrinking Database Files – Notes from the Field #023
Many shops have had jobs shrinking database files for years. Tim shares a simple script to find those jobs so you can deal with them.
A Shrink That Stops Blocking Others: SHRINKFILE WAIT_AT_LOW_PRIORITY
A shrink at 4 PM on Friday can block your whole app. See what the low-priority option does, and why shrinking is still a rare tool.