Finding Sister Locations to Help Each Other: Answers & Discussion
This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database: Locations […]
Query Exercise Answers
Find Recent Superstars: Answers & Discussion
Your query exercise for this week was to write a query to find users created in the last […]
Finding Long Values Faster: Answers & Discussion
In last week’s Query Exercise, our developers had a query that wasn’t going as fast as they’d like: […]
Improving Cardinality Estimation: Answers & Discussion
Your challenge for last week was to take this Stack Overflow database query to show the top-ranking users […]
Database Changes to Find Tagged Questions Faster: Answers and Discussion
In the last Query Exercise discussion, we hit a performance wall when we were trying to quickly find […]
Finding Tagged Questions Faster: Answers & Discussion
Your query exercise was to take this Stack Overflow query to find the top-voted questions for any given […]
Finding the Best Time for Maintenance: Answers & Discussion
Your Query Exercise was to find the best time to do database maintenance by querying the Users table, […]
Find Posts with the Wrong CommentCount: Answers & Discussion
Your Query Exercise was to find denormalization accuracy problems: checking the accuracy of a reporting column, Posts.CommentCount. There […]