WHERE @SearchVal NOT LIKE '%[^0-9.]%'
AND LEN(@SearchVal) - LEN(REPLACE(@SearchVal,'.','')) < 2

The solution will involve ROW_ NUMBER() OVER (PARTITION BY empnum ORDER BY email DESC, LEN(<name field you're measuring> DESC)

A few things:
1. The plan you attached is the Estimated Plan which will not be helpful here
2. A TOP (10) - that will affect the execution plan, what...

It depends on how much far back you want to go. I don't think I've ever done a point-in-time restore to the any system database so, for me, simple is...

I'm in Chicago, IL and can only speak about what I've seen in America. From what I'e seen, more and more companies are allowing remote work. Our DBA works from...

I guessed correctly. Good question!