I raised another thread yesterday (still ongoing) where angell gave me the idea of using filtered indexing in sql 2008. Thats going well.
I would like to get some understanding of how you decide which statistics to create. Here's some thoughts on possible strategies:
1. Just blindly run database engine tuning advisor and create the stats it suggests. When I previously followed this approach with indexes I ended up with mostly fast queries but sql was sometimes using the wrong indexes and the index size was abou 12GB. Now my index size is about 3.5GB as I created all the indexes manually - now all my queries are subsecond but I distrust database engine tuning advisor for those reasons.
2. Create statistics covering every column mentioned in each index - so the stats become a copy of the indexes effectively
3. Create statistics covering every column mentioned in each query - so the stats list off the columns in each sql statement in your "workfile"
4. Some other strategy not listed above ?
I just need some understanding of how you guys approach the problem of which stats to create. How do you decide ??