title: SQL Server Job creating large output file
body: <p>I have a query that I want to run as a job, but it creates a VERY LARGE output file.  I can run the query in SQL Studio and it runs pretty fast, I then direct the output to a file.  It creates the file at around 2 meg.  I then create it as a job and select to create a new output file each time.  The job takes longer to run and the output comes out as 1.2 gigs in size. There is a lot of white space in the output file. Am I missing something in creating this job and output?</p>