Timeline for SELECTING TOP X based on last 30 days of activity
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 2 at 19:33 | comment | added | Zoinky | I made an edit with your suggestions and results, the only thing that made a difference was the index suggested by sql server (no idea if its more efficient or not), see the edit part of the original pst | |
| Jan 2 at 17:49 | vote | accept | Zoinky | ||
| Jan 2 at 19:23 | |||||
| Jan 2 at 16:39 | comment | added | J.D. | @Zoinky No worries, please see my updated answer. | |
| Jan 2 at 16:38 | history | edited | J.D. | CC BY-SA 4.0 |
added 511 characters in body
|
| Jan 2 at 14:41 | comment | added | Zoinky | Modified the original q to not include indexed views, but not sure how columnstore index would help with the query posted in the new question/post, apologies for noob questions | |
| Jan 2 at 13:50 | history | answered | J.D. | CC BY-SA 4.0 |