How unique is User creation date?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Seems to be mostly unique except for some starting hiccups on the big sites and some ongoing sequential clone problems.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 50000
            COUNT (u1.Id)       AS [Num Users]
            , u1.CreationDate
            , UserIds = STUFF ( (
                    SELECT      N', ' + CAST (u2.Id AS NVARCHAR)
                    FROM        Users u2
                    WHERE       u2.CreationDate = u1.CreationDate
                    ORDER BY    u2.Id
                    FOR XML PATH (N''), TYPE
                ).value (N'.[1]', N'nvarchar(max)'), 1, 2, N''
            )
            /*-- Note that SEDE currently does not do more than 1 link per column. */
            , [First User link] = (
                SELECT TOP 1
                            'site://users/' + CAST (u2.Id AS NVARCHAR) + '|' + CAST (u2.Id AS NVARCHAR)
                FROM        Users u2
                WHERE       u2.CreationDate = u1.CreationDate
                ORDER BY    u2.Id
            )
FROM        Users u1
GROUP BY    u1.CreationDate
HAVING      COUNT (u1.Id) > 1
ORDER BY    [Num Users] DESC
            , u1.CreationDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results