Groups > comp.databases.ms-sqlserver > #2125

Re: Limiting memory usage

Path	csiph.com!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From	Anton Shepelev <anton.txt@g{oogle}mail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Limiting memory usage
Date	Thu, 5 May 2022 13:18:53 +0300
Organization	A noiseless patient Spider
Lines	18
Message-ID	<20220505131853.27394a7eaa57dcfac1ce2b32@g{oogle}mail.com> (permalink)
References	<20220505124052.0ca7954a09edb5ff9ad84a0f@g{oogle}mail.com>
MIME-Version	1.0
Content-Type	text/plain; charset=US-ASCII
Content-Transfer-Encoding	7bit
Injection-Info	reader02.eternal-september.org; posting-host="2449edb3eed30522b3b12486c78c2995"; logging-data="30138"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/HM0OEuU5OG0oagQe3UPKyYmJfM1YH9NM="
Cancel-Lock	sha1:6qfdVdbLByKQsvc0+vQ484HcK30=
X-Newsreader	Sylpheed 3.5.0 (GTK+ 2.24.23; i686-pc-mingw32)
Xref	csiph.com comp.databases.ms-sqlserver:2125

Show key headers only | View raw

I wrote:

> SELECT
>    #LOG.m_used               AS  Used       ,
>    #LOG.m_max                AS [Max]       ,
>    #LOG.m_used - #LOG.m_max  AS [Overrun]   ,
>    PREV.m_used - #LOG.m_used AS [Delta Used],
>    PREV.m_max  - #LOG.m_max  AS [Delta Max]
> FROM      #LOG
> LEFT JOIN #LOG PREV ON PREV.N = #LOG.N - 1

I forgot to ORDER BY #LOG.N , because the results were
already ordered that way, but I understand it is merely a
coincidence, albeit a likely one :-)

-- 
()  ascii ribbon campaign - against html e-mail
/\  http://preview.tinyurl.com/qcy6mjc [archived]

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Limiting memory usage Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-05 12:40 +0300
  Re: Limiting memory usage Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-05 13:18 +0300
  Re: Limiting memory usage Erland Sommarskog <esquel@sommarskog.se> - 2022-05-05 21:28 +0200
    Re: Limiting memory usage Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-11 12:48 +0300
  Re: Limiting memory usage Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-07-04 14:31 +0300
    Re: Limiting memory usage Erland Sommarskog <esquel@sommarskog.se> - 2022-07-05 09:45 +0200
      Re: Limiting memory usage Anton Shepelev <antonius@freeshell.de> - 2022-07-05 12:16 +0300
        Re: Limiting memory usage Erland Sommarskog <esquel@sommarskog.se> - 2022-07-05 21:27 +0200
          Re: Limiting memory usage Anton Shepelev <anton.txt@gmail.com> - 2022-07-06 00:45 +0300

csiph-web