No I wanted to output tables that was missing one or the other or both, not just both. HasPrimarykey+HasClusteredIndex is in the order by so tables missing both will...

Yeah most of my utility procs need to be saved-in and run-from the database you need the data from, primarily because of the joins to database-level catalog views (sys.objects, sys.indexes...

The missing index DMVs this qry is based on often report missing indexes that, if created, would have too many columns... Imagine the performance impact when you go to do...

http://www.sqlservercentral.com/scripts/Index+Management/63937/

There seems to be one other topic that has the same problem also - What to do with Multiple Similar Index Reccommendations

Yes for the first two:

StrategyCode, HistoryDate

RRCode

3rd:

one index on TransactionAction, TrasactionEntityType,PrcessStatusFlag

Don't neglect the includes

The missing index views don't account for clustered index inheritance. Clustered index seek columns are appended to...

They are not unnecessarily recommended indexes. They are index combinations that the optimizer wanted to have but didn't.

In your case, I would make one index that encompasses all three...

I submitted 'The Ultimate Table Searcher Mk2' that adds PartitionCount, IndexCount, ColumnCount, TotalMaxColumnLength, HasPrimaryKey, and HasClusteredIndex.

It only outputs indexes that have common first seek columns. Indexes that have common first seek columns are dupes or might be merge-able, or the one of the indexes...

user_* is anything initiated by the user

system_* is anything initiated by the server - statistics updates etc...

Seeks are seek operations (index seek, clustered index seek)

Scans are scan operations (index scan...

Included columns are available only to cover to query (prevent bookmark lookups), but not for seeks. Included columns can assist in exploiting the fact that clustered indexes append its...

We have the issue with provider worklist at Carle Clinic. I think it is a SQL server bug that involves recording data in the DMVs. Might be a...

I submitted a fix for the existance check. The 'U' should be 'P'. Several other of my submissions had the same issue and I submitted fixes for them...

You need to place it in the database you need to get results for. Had to make it that way to be sure to be able to get table...

Ideally you would want to run this on a database with production load. If you can't, QA load is a distant 2nd-place alternative. DEV traffic won't get much...

Are you using -x option for the startup options for the service (or when starting manually from the command line)? It disables some DMV data collection (not sure if...