title: Sorting very large amount of data in SQL Server 2005
body: <p>I have a SSIS package in which I am taking 30 million records to sort. But this taking so much time. Is there any efficient way to sort large amount of data? Memory in the drive is less compare to the data....</p>