Hello, (I hope I'm posting this in the right place)
We are exporting some tables to text to give to a client. We set query results to file to create .rpt files (SQL Server 2005). When one user did this, the resulting files were huge. Another user on the same tables/database/server got much smaller files. The files do not have any oversized text fields, etc. Can anyone explain this?
(File/Rows/Size of text file for User 1/Size of text file for User 2)
File 1: 1,667,469 rows/ User 1 rpt: 1.7GB/ User 2 rpt: 253MB
File 2: 515,120 rows/ User 1 rpt: 379MB/ User 2 rpt: 96MB
File 3: 15,215,975 rows/ User 1 rpt: 24.4GB/ User 2 rpt: 2.5GB
Thanks for any feedback.