Michael Smith


Technical Article

Prioritize Missing Index Recommendations (2005)

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.

You rated this post out of 5. Change rating

2007-08-17

979 reads

Technical Article

Prioritize Missing Index Recommendations 2 (2005)

This is an enhanced version of my previous script: Prioritize Missing Index Recommendations (2005).To aid in evaluation of whether the recommended index is reasonable, I have added :1. counts for key columns and the total columns of the recommended index  2. the length/bytes for both key and all columns  Note this is 'per row', not […]

5 (2)

You rated this post out of 5. Change rating

2007-08-17

1,844 reads

Blogs

The pros and cons of self-service BI: What every industry leader should know

By

The post The pros and cons of self-service BI: What every industry leader should...

Off to the PASS Data Community Summit 2024

By

As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...

Implement a RAG Solution Using Azure SQL Database

By

AI and ChatGPT are all the rage these days.  Seems like around every corner...

Read the latest Blogs

Forums

Database deployment on-prem vs data center

By Casper101

We currently have a number of applications connecting to a SQL Server 2022 database....

SQL 2022 - CPU High Utilization

By haichells

Dear All, We have been facing this issue from last 3 months and unable...

Cloud Sources for the Data Migration Assistant

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud Sources for the Data...

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers