User Darthtong - Database Administrators Stack Exchange

1. Home
2. Questions
3. Tags
5. Users
6. Jobs
7. Companies
8. Unanswered
Teams

Ask questions, find answers and collaborate at work with Stack Overflow for Teams.
Try Teams for free Explore Teams
Teams
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams

Darthtong

Member for 12 years, 4 months
Last seen more than 11 years ago

Manchester, United Kingdom

Network profile

14 Actions

All Accepts Posts Badges Comments Revisions Reviews Suggestions

awarded

Famous Question

Oct 21, 2023 at 21:18

awarded

Yearling

Nov 13, 2019 at 20:51

awarded

Notable Question

Jun 8, 2017 at 10:16

awarded

Notable Question

Jul 23, 2015 at 7:51

awarded

Popular Question

Jan 8, 2015 at 9:45

awarded

Popular Question

Jul 4, 2014 at 13:14

asked

Non-Clustered Indexes - keys and nonkeys

Aug 17, 2012 at 16:48

Loading…

comment

Speeding up COUNT(*) - WHERE clause slowing query

And you were right, the filtered index wasn't used by the optimizer

Aug 14, 2012 at 16:47

comment

Speeding up COUNT(*) - WHERE clause slowing query

Thanks for the suggestion but it did nothing for the query time

Aug 14, 2012 at 16:28

awarded

Student

Aug 13, 2012 at 16:44

asked

Speeding up COUNT(*) - WHERE clause slowing query

Aug 13, 2012 at 16:38

Loading…

awarded

Scholar

Aug 13, 2012 at 16:29

accepted

INNER JOIN making COUNT(*) slow

Aug 13, 2012 at 16:25

asked

INNER JOIN making COUNT(*) slow

Aug 13, 2012 at 15:30

Loading…