I want to find the list of questions on a site that have the longest titles.
The purpose is testing design elements that might break or have layout problems if the title is too long. It's also an interesting query by itself, but searching visually through the questions listing is just too frustrating.
Here's your query. You can adjust the number in SELECT TOP 100 to change the number of rows returned. Note that the ordering among posts tied for title length is arbitrary, and changes from execution to execution.
SELECT TOP 100 Id as [Post Link], Title
ORDER BY LEN(Posts.Title) DESC