Q&A for community managers, administrators, and moderators
DECLARE @DbNow DATETIME; SELECT @DbNow = MAX(CreationDate) FROM PostsWithDeleted; SELECT TOP 1000 Id, Id AS [Post Link], CreationDate, ViewCount, 1.0 * ViewCount / DATEDIFF(s, CreationDate, @DbNow) AS ViewPerSec FROM PostsWithDeleted WHERE PostTypeId = 1 AND CreationDate < @DbNow ORDER BY ViewPerSec DESC