Database Maintenance - Category Archive
The following is a list of all entries from the Database Maintenance category.
How Do You Defragment Your SQL Server Indexes
Database Administration,Database Maintenance,Performance Tuning | August 18, 2010 | 11:05 amI give a lot of presentations based on best practices, and in all of them I stress the importance of regularly rebuilding or reorganizing indexes. Both the REBUILD and the REORGANIZE options have their pros and cons, so I thought it would be interesting to do a poll to see which method(s) was preferred by ...read more
Instant File Initialization Speeds SQL Server
Database Administration,Database Maintenance | July 21, 2010 | 9:20 amSometimes, its just the smallest of details that can make all the difference. For example, on my test system (see the end of this posting for a description), I created a new 50GB database. The database creation process took about 5 minutes and 50 seconds to complete.
SQL Server Monitoring Checklist
Database Administration,Database Maintenance | May 3, 2010 | 12:05 pmI have worked with a lot of organizations who have just a small handful of SQL Server instances. In most of these cases, these SQL Servers contain mission-critical data, but on the other hand, these organizations are not big enough to justify a full-time DBA, so either they subcontract the DBA work to an outside ...read more
How Many DBAs Use the Maintenance Plan Wizard/Designer?
Database Administration,Database Maintenance | March 30, 2010 | 2:44 pmWhen I wrote my most recent free eBook, Brad’s Sure Guide to SQL Server Maintenance Plans, some of the DBAs I know asked me why I wrote it. After all, “real” DBAs don’t use the Maintenance Plan Wizard/Designer built into SQL Server 2005/2008 Management Studio (SSMS) to maintain their databases, they write Transact-SQL or PowerShell ...read more
Free SQL Server Training Webinar Series
Conferences,Database Administration,Database Maintenance,DBA Career,Speaking Schedule | February 12, 2010 | 12:11 pmSQLServerCentral.com, PragmaticWorks, and Wrox Press are sponsoring a series of free SQL Server webinars in February. Called the SQL Server 101 Series, the sessions include: Introduction to Managing a SQL Server Database with Jorge Segarra Beginning T-SQL with Patrick LeBlanc The Modern Resume with Steve Jones How to Become an Exceptional DBA with Brad McGehee ...read more
DBA Checklist Updated
Database Administration,Database Maintenance | January 22, 2010 | 12:49 pmI have recently updated and revised my DBA Best Practices Checklist, which is hosted on www.Simple-Talk.com. The goal of the list is not to cover every aspect of SQL Server administration, but to hit the highlights. In addition, not every item in the checklist will apply to every SQL Server instance, under every circumstance. So ...read more
Creating the SSC Maintenance Plan: Part 3
Database Administration,Database Maintenance,Indexing | January 20, 2010 | 3:51 pmNote: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could be implemented on a single, plain vanilla, SQL Server instance. As I have mentioned in previous parts of this article series (part 1, part 2), I act as a consultant DBA for the SQLServerCentral.com (SSC) ...read more
What Would You Like to See in a New Book on Indexing?
Books,Database Administration,Database Maintenance,Indexing | | 9:20 amI am currently in the early stages of writing an outline for a new book on indexing, targeted towards novice DBAs. While this topic has been done to death in hundreds of articles, presentations, and books, I think there is still room for a book that makes the topic easy to read and easy to ...read more
Twitter
Linked In