Script out/store all indexes on a server
This script will store all index definitions into a table that you can use to "re-create" the indexes at a later date.
2015-03-11 (first published: 2013-08-26)
2,583 reads
This script will store all index definitions into a table that you can use to "re-create" the indexes at a later date.
2015-03-11 (first published: 2013-08-26)
2,583 reads
In this article Greg Larsen will show you how to identify when your index statistics were updated last, what method was used to gather statistics, and how to update your statistics.
2013-07-11
3,074 reads
2013-06-14
2,572 reads
Script will give you the list of fragemented indexes.
(For SQL 2005-2008)
2013-06-21 (first published: 2013-05-31)
1,913 reads
Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1 introduced selective XML indexes. These transform the practicality of querying large amounts of XML data. Seth Delconte demonstrates how and why this feature makes all the difference.
2013-02-06
2,578 reads
Script to reorganize all indexes on all tables in user databases
2013-02-14 (first published: 2013-01-31)
3,226 reads
In earlier installments of this series we looked at T-SQL Performance optimizations along with different T-SQL practices, we can now turn our attention to the second part of this series which is index Tuning
2013-01-30
5,192 reads
A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly
2013-02-19 (first published: 2013-01-29)
2,112 reads
Sometimes, you have to test out alternative indexing strategies, but the task of creating the candidate indexes would just take too long. Is there another way? Well, yes, why not use the same method the DTA (Database Tuning Advisor) uses, and take the tedium out of the job.
2013-01-22
3,343 reads
The "index create memory" option in sp_configure advance server settings, controls the maximum amount of memory initially allocated for creating indexes. This tip deals with common issues around this setting.
2012-12-28
3,267 reads
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
I wrote a PowerQuery that parses a table from a PDF, and I want...
Comments posted to this topic are about the item Attaching an SQL Server database...
Comments posted to this topic are about the item Superseded Indexes
Which of these indexes is superseded by another?
See possible answers