Access your Pro+ Content below.
Top 5 SQL Server DBA tasks that are a waste of time
This article is part of the SQL Server Insider issue of February 2010, Vol. 1
Some tasks performed by DBAs on a regular basis not only have little to no benefit to SQL Server, but can actually be detrimental to the health of their environments. In this article I'll cover a few such tasks. If you are doing any of these, I would hope that you stop doing them as soon as possible. #1. Shrinking the database Daily shrinking of the database is bad for a few reasons. From the technical side, the biggest impact you will see is a greatly increased index fragmentation after each database shrink. In addition, shrinking the database files increases both the physical file fragmentation on the disk subsystem and the I/O load on the server, which decreases performance for other functions while the shrink operation is running. Now it isn't the actual shrinking of the database that causes fragmentation, but as the files regrow themselves and you continue to shrink them, the database will become more and more fragmented as it autogrows. SQL Server Mailbag Each month (nearly), Denny Cherry asnwers questions from our readers...
Access this PRO+ Content for Free!
Features in this issue
While Microsoft’s PowerPivot technology promises to empower users to make decisions based on their own analyses, self-service business intelligence has a dark side as well.
While some DBA tasks are less important than most, others can be completely pointless. Could you be wasting valuable time without even knowing it?
News in this issue
Microsoft's new master data management technology could be a major factor for those pondering an upgrade to SQL Server 2008 R2.