Access "Top 5 SQL Server DBA tasks that are a waste of time"
This article is part of the February 2010, Vol. 1 issue of Is self-service BI the answer?
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 dealing with a variety of SQL... Access >>>
Premium Content for Free.
Is self-service business intelligence the answer?
by Eric Johnson, Contributor
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.
- Is self-service business intelligence the answer? by Eric Johnson, Contributor
Top 5 SQL Server DBA tasks that are a waste of time
by Denny Cherry, Contributor
While some DBA tasks are less important than most, others can be completely pointless. Could you be wasting valuable time without even knowing it?
- Top 5 SQL Server DBA tasks that are a waste of time by Denny Cherry, Contributor
Master Data Services could spur SQL Server 2008 R2 migrations
by Brendan Cournoyer, Site Editor
Microsoft's new master data management technology could be a major factor for those pondering an upgrade to SQL Server 2008 R2.
- Master Data Services could spur SQL Server 2008 R2 migrations by Brendan Cournoyer, Site Editor
More Premium Content Accessible For Free
These days, virtual servers are often seen as time- and money-saving efforts for businesses. When deciding if going virtual is the right thing to do,...
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business ...
Microsoft has worked to address the big issue of "big data," as companies are dealing with a constant influx of digital information. SQL Server is no...