1

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited may 12 19

created may 12 19 peterh - PLEASE DELETE THIS ACCOUNT