Hej,
I'm not facing this issue but as I was working another parameter sniffing issue I came to think about this and if it might cause an issue?
So I'm more looking for your experience in the past and more an answer of kind "Nah, you'r good" or "You should definitely go with rounding to whole hours or whole dates".
Example (Parameters = @FromDate and @ToDate):
EXEC Myproc '2024-10-14 08.45.00', '2025-10-14 08.45.00'
EXEC Myproc '2024-10-14 08.47.00', '2025-10-14 08.47.00'
EXEC Myproc '2024-10-14 08.53.00', '2025-10-14 08.53.00'
EXEC Myproc '2024-10-14 08.59.00', '2025-10-14 08.59.00'
As the above is a period of a year it hasn't to be exact when it comes down to how many rows are returned.
OR
EXEC Myproc '2024-10-14 00.00.00', '2025-10-15 00.00.00'