jitendra.padhiyar (1/8/2013)
1. Is it using indexing and sorting for this process ?2. Is it using TempDB for data collection (for static purpose) ?
NO.
Have you read the link which arjun posted ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)