163 reputation
2
bio website
location Manchester, United Kingdom
age 30
visits member for 1 year, 8 months
seen Aug 23 '13 at 14:44

Aug
17
asked Non-Clustered Indexes - keys and nonkeys
Aug
14
comment Speeding up COUNT(*) - WHERE clause slowing query
And you were right, the filtered index wasn't used by the optimizer
Aug
14
comment Speeding up COUNT(*) - WHERE clause slowing query
Thanks for the suggestion but it did nothing for the query time
Aug
13
awarded  Student
Aug
13
asked Speeding up COUNT(*) - WHERE clause slowing query
Aug
13
awarded  Scholar
Aug
13
accepted INNER JOIN making COUNT(*) slow
Aug
13
asked INNER JOIN making COUNT(*) slow