Erik Darling does an odd search:
Most of the time, it’s some query that looks like this:
c = COUNT_BIG(*)
FROM dbo.Posts AS p
WHERE p.OwnerUserId LIKE ‘2265%’
The cruddy thing here is that… SQL Server doesn’t handle this well.
At first, my thought was, “Why not just use an inequality operator like
p.OwnerUserID >= 22650000 AND p.OwnerUserID < 22660000 but then I remembered that we’re probably dealing with multiple orders of magnitude here and the whole thing made my head hurt a little.