Viewing 3 posts - 1 through 3 (of 3 total)
The problem with Parameter Sniffing occurs where the execution plan is optimized for small data as a result (here SQL can be quite lazy) and you mostly want big data, where...
October 24, 2017 at 2:02 am
#1964911
Looks like a typo in the question.
You have the values 100/50/50/120/110 in the posted question.
This would give the results 1, 2, 3, 4, 4 with both RANK() and DENSE_RANK(). You...
October 3, 2014 at 1:19 am
#1749880
Tested on SQL 2005 and SQL 2008
If run against Master: 6 distinct values returned
If run against any other database: 2 distinct values are returned.
The question would therefor be invalid due...
October 1, 2014 at 7:41 am
#1749394