INF: ISQL Is Faster When Output Is Sent to Disk File

ID: Q73212

The information in this article applies to:

Microsoft SQL Server versions 4.2x, 6.0, 6.5, 7.0, 7.0 Service Pack 1

SUMMARY

Performing large queries or using the DBCC CHECKALLOC or DBCC CHECKDB commands can generate a great deal of output. When using ISQL, the execution speed of these queries increases significantly if you send the output from ISQL to a hard disk file.

MORE INFORMATION

For example, execute SELECT * FROM MASTER..SYSMESSAGES from ISQL. On one test computer, sending the output to the screen took about one minute and 30 seconds. Sending the output to a hard disk file took less than 15 seconds.

To direct the output to a file, run ISQL with the following command line:

ISQL /S<server> /U<login> /P<password> /i<input_file> /o<output_file>

where <input_file> is an ASCII text file that contains the TRANSACT-SQL commands and <output_file> is the disk file that stores the results. Note that the command is case-sensitive and there are no spaces between the switches and the parameters. For example:

ISQL /Sgizmo /Usa /P /isqlin.txt /osqlout.txt

Additional query words:

Keywords : kbtool SSrvISQL
Version : winnt:4.2x,6.0,6.5,7.0,7.0 Service Pack 1
Platform : winnt
Issue type :