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>
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

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]