| bio | website | |
|---|---|---|
| location | Manchester, United Kingdom | |
| age | 29 | |
| visits | member for | 10 months |
| seen | Aug 22 '12 at 14:35 | |
| stats | profile views | 3 |
|
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 |