Indexing - Category Archive
The following is a list of all entries from the Indexing category.
When was the Last Time You Removed an Index Because it was Never Used?
Database Maintenance,Indexing,Performance Tuning | August 11, 2011 | 11:16 amIndexes can be great for boosting the performance of a query, but if an index is never used, it can drag down an instance’s performance. This is because unused indexes must be maintained just like any index. For example, anytime a row is inserted, updated, or deleted, indexes must be maintained. If a lot of ...read more
Two Blog Series You Don’t Want to Miss
Database Administration,Indexing,Performance Tuning | May 28, 2010 | 1:52 pmBlogs are a great way to learn new things about SQL Server, and just in case you have missed them, I want to recommend the following two blog series that I feel every DBA should read.
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
Don’t Forget to Maintain Your Indexes
Indexing | August 8, 2009 | 3:22 amSo long as data is inserted, updated and deleted from tables, indexes will become fragmented over time, and performance will suffer. Index maintenance is vital to keeping databases and their users happy. In this article, I go through the key index maintenance tasks and identify more essential areas that are a DBA’s duty to maintain. ...read more
Brad’s Sure Guide to Indexes
Indexing | | 3:21 amThere are many different types of index that exist in SQL Server. In this guide, I look at what a table and index are, before exploring how SQL Server 2005 and 2008 indexes work, including those that are filtered, special and compressed. Read more…
Don’t Make Dumb Mistakes by Duplicating Indexes
Database Maintenance,Indexing | April 15, 2009 | 3:59 pmJust today, I was reviewing the indexing of a database used by a third-party application. As part of my review, I ran a script against it that is used to identify duplicate indexes. The script I used was written Paul Nielsen, the author of the SQL Server Bible; and Itzik Ben-Gan. The script is available ...read more
Reasons Why You May Not Want to Use a Heap
Indexing,Performance Tuning | February 27, 2009 | 4:41 pmI have started compiling a list of reasons why heaps aren’t usually a good choice when designing a database. Now, I didn’t say that heaps are always bad, but in most cases, I think they should be avoided (read the list to see why). As I compiled the list, in some cases I have had ...read more
Twitter
Linked In