Hi Masters,
I have been searching some posts about sort warning which have a lot of impact to database performace since it do not fit onto memory and spill over to disks.
The question is when i ran a profiler and tried to catch a sort warning i cannot find the query which cause the alert. Can someone help me how to find the culprit. Thank you.
-----------------------------------------------------------
I am here to learn from all SQL Server masters. 😀