I am using the DMV views to get a list of index recommendations and then I am reviewing each of them to make sure they make sense and don't overlap etc.
Some examples are
Index ON X ( Y ) and Table X already has the
INDEX Y. So far this is for non clustered indexes and the indexes have been defragmented.
SQL Server 2008 R2, database is fairly busy and lots of index recommendations are coming up. Right now it's hard to see the wood for the trees; I am just trying to get some low hanging fruit to start with.
I have checked the last access times and they're all recent.
SQL Server version I'm using is:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4033.0 (X64) Jul 9 2014 16:04:25 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.2 (Build 9200: )