• For the fun of it you wish you could increase the TEMPDB to 93000TB and then watch how the developer handles the resultset in the application. He probably will loop through each row to get to the single one row he needs....

    Edit: forgot to type the 0's with the required size. I'm not used to deal with such high volumes...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **