iZom

I’m a hoarder in these games. If I can store all my stuff back at my base like in Fallout 4 and Skyrim then I’m happy. As long as they don’t pull the Fallout 76 stunt where you need to pay monthly for extra storage.

Glad this is working for you. Using TOP probably was a bad idea and I think the way you used RANK <=1000 is a better approach.

If there was a way to safely exclude any of the records - like if you knew that when published was older than X days/months/years it would never make it into the final results, you could filter them out before ranking them. That might squeeze a little more performance out of the query, but could be risky if the data isn’t predictable enough.

I think you can use RANK as a window function and specify TOP 1000

Depends on my mood but probably - Bojack, Mr. Robot, Parks & Rec, Community, Trailer Park Boys or Brooklyn 99.

Does Auld Lang Syne count?

Learn to play an instrument. Try a hobby; crafts, woodwork, painting. Learn a language. Join a local chess club. Volunteer for a local charity. Just keep trying stuff until you find something that is right for you.