Microsoft KB Archive/73212

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

Article ID: 73212

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 7.0 Service Pack 1

-



This article was previously published under Q73212



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 /U /P /i /o

where  is an ASCII text file that contains the TRANSACT-SQL commands and  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

Keywords: KB73212

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.