SSMS Clipboard

27 Nov 2006 4:05 PM

Mike Caputo

I frequently have to copy fairly large datasets from an SSMS result set into
Excel. This works fine, except that it seems each time I do a copy/paste,
the copied data remains in memory - but not visible on the clipboard. So if
I copy 55K rows X 15 columns, this increases the amount of memory being used
by SSMS by around 150 MB. Then when I check the clipbrd utility, nothing
appears, so the only way to free this memory is to restart SSMS.

I can't imagine I'm the only one with this problem, but I can't find other
posts about it. Anyone have any ideas?

27 Nov 2006 5:58 PM

Arnie Rowland

Often, the quality of the responses received is related to our ability to
'bounce' ideas off of each other. In the future, to make it easier for us to
give you ideas, and to prevent folks from wasting time on already answered
questions, please:

Don't post to multiple newsgroups. Choose the one that best fits your
question and post there. Only post to another newsgroup if you get no answer
in a day or two (or if you accidentally posted to the wrong newsgroup -and
you indicate that you've already posted elsewhere).

If you really think that a question belongs into more than one newsgroup,
then use your newsreader's capability of multi-posting, i.e., posting one
occurrence of a message into several newsgroups at once. If you multi-post
appropriately, answers 'should' appear in all the newsgroups. Folks
responding in different newsgroups will see responses from each other, even
if the responses were posted in a different newsgroup.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

Show quote

"Mike Caputo" <MikeCap***@discussions.microsoft.com> wrote in message
news:4A8CCF9D-6319-4C40-93C6-294F88FE8EFF@microsoft.com...
>I frequently have to copy fairly large datasets from an SSMS result set
>into
> Excel. This works fine, except that it seems each time I do a copy/paste,
> the copied data remains in memory - but not visible on the clipboard. So
> if
> I copy 55K rows X 15 columns, this increases the amount of memory being
> used
> by SSMS by around 150 MB. Then when I check the clipbrd utility, nothing
> appears, so the only way to free this memory is to restart SSMS.
>
> I can't imagine I'm the only one with this problem, but I can't find other
> posts about it. Anyone have any ideas?

28 Nov 2006 2:21 PM

Mike Caputo

Whoooah... easy there, Sparky. Change the parameters in your auto-response
script to at least wait for triple or quad posts. Two is NOT a big deal.

And for the record, I didn't double-post at first because I wanted to avoid
exactly this kind of hassle. I just wasn't sure whether people would think
of SSMS as a Tool or as SQL General, and when I saw the relative infrequency
of posts in Tools, I thought I was more likely to get a response from
General. Though so far, your generic little hissy fit is the only response
I've gotten in either forum.

Take a pill, Stormin' Arnie.

Show quote

"Arnie Rowland" wrote:

> Often, the quality of the responses received is related to our ability to
> 'bounce' ideas off of each other. In the future, to make it easier for us to
> give you ideas, and to prevent folks from wasting time on already answered
> questions, please:
>
> Don't post to multiple newsgroups. Choose the one that best fits your
> question and post there. Only post to another newsgroup if you get no answer
> in a day or two (or if you accidentally posted to the wrong newsgroup -and
> you indicate that you've already posted elsewhere).
>
> If you really think that a question belongs into more than one newsgroup,
> then use your newsreader's capability of multi-posting, i.e., posting one
> occurrence of a message into several newsgroups at once. If you multi-post
> appropriately, answers 'should' appear in all the newsgroups. Folks
> responding in different newsgroups will see responses from each other, even
> if the responses were posted in a different newsgroup.
>
>
>
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
>
> "Mike Caputo" <MikeCap***@discussions.microsoft.com> wrote in message
> news:4A8CCF9D-6319-4C40-93C6-294F88FE8EFF@microsoft.com...
> >I frequently have to copy fairly large datasets from an SSMS result set
> >into
> > Excel. This works fine, except that it seems each time I do a copy/paste,
> > the copied data remains in memory - but not visible on the clipboard. So
> > if
> > I copy 55K rows X 15 columns, this increases the amount of memory being
> > used
> > by SSMS by around 150 MB. Then when I check the clipbrd utility, nothing
> > appears, so the only way to free this memory is to restart SSMS.
> >
> > I can't imagine I'm the only one with this problem, but I can't find other
> > posts about it. Anyone have any ideas?
>
>
>