168 reputation
3
bio website
location Manchester, United Kingdom
age 31
visits member for 2 years, 2 months
seen Aug 23 '13 at 14:44

Jul
4
awarded  Popular Question
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