Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 4
Impact
~4k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Jul
23
awarded  Notable Question
Jan
8
awarded  Popular Question
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