To report indexes proposed by the database engine that have highest probable user impact. Note that no consideration is given to 'reasonableness' of indexes-- bytes, overall size, total number of indexes on a table, etc. Intended to provide targeted starting point for holistic evaluation of indexes.
2007-08-17
983 reads
This script will find foreign keys (on referencing table) that are not indexed in SQL Server 2005.
2011-12-20 (first published: 2007-08-10)
3,758 reads
Check Indexes on all databases and rebuild/reindex based on fragmentation
2008-02-01 (first published: 2007-04-05)
1,454 reads
2007-04-30 (first published: 2007-04-03)
1,684 reads
Since it is not possible to script only the primary keys of all tables with the SQL Server 2005 Management Studio, here a small script to get the create scripts for all existing primary keys of the current database.
2007-03-28 (first published: 2007-03-09)
4,293 reads
When AUTOSTATS is used in a database, we can sometimes use these automatically generated statistics to find columns where SQL Server has built statistics on non-indexed columns that may benefit from an index. This script finds these columns and displays the selectivity of them. This script can be useful in troubleshooting poorly performing databases by […]
2007-04-09 (first published: 2007-02-20)
1,748 reads
Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database.
2007-12-13 (first published: 2006-12-20)
14,358 reads
This script will drop and recreated all indexes in a database within a transaction. The script will also add standard nameing conventions to the index names. Any duplicated indexes are removed.
2007-07-20 (first published: 2006-10-24)
1,377 reads
Most of the time even after executing dbcc dbreindex script on database you won't see much improvement in application/DB performance. Thats because dbreindex creates statistics for all tables but it executes sp_updatestats which is like sample statistics. To get the maximum performance we had to execute Update statistics with fullscan on table. This simple will […]
2006-12-22 (first published: 2006-10-23)
21,062 reads
The below command will rebuild all indexes on a database.We need to run the below command in the context of each database that is of interest.
2007-02-21 (first published: 2006-10-23)
1,226 reads
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
I wanted to try out the new JSON index which is for the moment...
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
Comments posted to this topic are about the item Learning a New Language
Hi, we have a few people who like to experiment on our prod sql...
Comments posted to this topic are about the item Guidelines and Requirements
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers