Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
With the Query Analyzer's Save Results feature, results of a statement execution can be saved to a variety of different file formats or copied to the clipboard for reuse or pasting elsewhere. The Save Results dialog can be launched by right clicking within a Query Results window and selecting "Save Results" from the popup menu. It can also be launched by clicking the Save Results icon, a floppy disk with a grid overlay, in the Query Analyzer Toolbar to the left of the Print icon.
The Save Results allows a wide variety of formats including, Delimited Data, INSERT statements, XML, HTML, and Excel worksheets. Selected Results can also be sent directly to the clipboard by clicking the "Save To Clipboard" button in the Save Results dialog. (Data Format for Excel does not save to clipboard).
For cases where large results sets (100,000 rows or more) are being dealt with, it is best to use Save Results instead of Save To Clipboard. Copying a large result set to the clipboard dramatically increases the RAM in use. Save Results streams data directly to disk and it is highly recommended that "Save Results" or Export be used instead of copying large amounts of data from a Grid Result.
Using the Operating System's clipboard for a large copy effectively doubles the amount of RAM in use because the Grid Result is already holding those items in memory. Saving to a file uses much less RAM, as a file is streamed to disk instead of being kept whole in memory.
Below are the steps for Save Results and a list of all of its options and settings.