Tim Radney (@tradney) discusses some aspects of the msdb database that probably require more attention than they currently get in a lot of environments.
Continue Reading »Jul 102015
Apr 202015
Paul Randal (@PaulRandal) of SQLskills provides some thorough and helpful tips on reducing or eliminating the impact of index fragmentation in SQL Server.
Continue Reading »Dec 222014
Erin Stellato (@erinstellato) of SQLskills continues her series on proactive SQL Server health checks, this time focusing on mastering maintenance tasks.
Continue Reading »Jun 102014
Updated July 23, 2014 : Aaron Bertrand (@AaronBertrand) of SQL Sentry warns about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds.
Continue Reading »Oct 162013
SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a quick look at performance of encrypted backups in SQL Server 2014, and points out a couple of other things you'll want to know before implementing the feature.
Continue Reading »Sep 132013
Joe Sack (@josephsack) takes a look at how online index operations have been improved to take advantage of parallelism in SQL Server 2014.
Continue Reading »Jul 022013
Erin Stellato (@erinstellato) of SQLskills.com dives into what sp_updatestats is really doing, and why you should avoid relying on it for perpetual maintenance on your SQL Servers.
Continue Reading »