jpomfret

-- Index stats are from the last restart - this will show you the days
select datediff(d,create_date,getdate())
from sys.databases
where name = 'tempdb'

/*

You can either run this with specific schema or table names or you can run it with % in those variables to get all indexes for a schema or for the whole database
 @schPat SYSNAME = '%'
,@tblPat SYSNAME = '%'

jpomfret

# quicker method

# get
kubectl delete pod --all-namespaces --field-selector=status.phase=Failed

# and delete
kubectl delete pod --all-namespaces --field-selector=status.phase=Failed