Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Parameter Sniffing In Action

    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...

  • RE: Ranking

    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...

  • RE: How Many Different Random Numbers?

    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...

Viewing 3 posts - 1 through 3 (of 3 total)