A client’s MSDB database had grown huge, and queue_messages tables were eating the space. Here is how to find them and clear all messages from a queue.
Interview Question of the Week #006 – Is Shrinking Database Good or Bad?
Is shrinking database good or bad? My short answer: it hurts performance by increasing fragmentation. Here is why, with links to read more.
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.
Why DBCC SHRINKFILE Crawls and How to Watch Its Progress
Explain why DBCC SHRINKFILE can take hours, monitor percent_complete and waits, and use TRUNCATEONLY before small steps.