Thanks for the replies.

yes I agree,filtered indexes, should be created based on the queries that access the tables. but through the above query, we categorize the candidates for filtered index. Then for those...

Hey thanks for the reply. I found a way to capture the histogram details for every index and check the candidate for filtered index based on the below condition---

If the...

Is there a way to find missing filtered index in database through DMV's apart from DTA(tuning advisor)? The sys.dm_db_missing_index_details DMV do not list the missing filtered columns

Sindhu Ravi (8/6/2014)

---

A sample table looks like below

iddate ...

A sample table looks like below

iddate ...

Restart SQL service (if downtime is permissible) and connect via DAC.

use select * from sys.dm_exec_requests to see what requests that is executed against the databases. You will see wait types,...

You can do this as below (note: Check for the performance issues before implementing)

declare @date datetime

select @date=MAX(date) from #mytable where method='B'

;with CTE...