Re: 64bit Proc Cache limit?

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 04/24/04 

Date: Fri, 23 Apr 2004 21:38:33 -0500

There are no such restrictions in 64bit. Virtually all of the available
memory for SQL Server is dynamic. 

--
Andrew J. Kelly  SQL MVP
"Don Peterson" <no1@nunya.com> wrote in message
news:#Z6TidVKEHA.3580@TK2MSFTNGP10.phx.gbl...
> I understand that there is a 2Gb limit to SQL Server's procedure cache,
> although I have found no official MS documentation that says so...
>
> My question is whether the 64bit version suffers the same limit?  Any
input
> and especially documentation would be much appreciated.
>
>

Relevant Pages

  • ANNOUNCE - Muldis::DB v0.0.0 released, in p5+p6
    ... I am pleased to announce the release of Muldis::DB version 0.0.0 for Perl 5 on CPAN. ... If you want to read all the Muldis::DB documentation that exists now, I recommend doing so in this order: ... Muldis::DB implements a D language as defined by Hugh Darwen and Chris Date, and presents a superior interface for working with the relational model of data, contrasted with SQL. ...
    (perl.dbi.users)
  • Re: Generating SQL
    ... > Scanning a bunch of column descripter classes for column ... a data dictionary documented in code - the value object class. ... > language that is uglier and/or less documented than SQL. ... > cannot find the documentation for your custom query API, ...
    (comp.object)
  • RE: Microsoft Jet SQL Reference
    ... The entire Jet 4.0 SQL Reference is on your hard drive in the following ... > I'm quite challenged by the CONSTRAINT clause documentation. ... > CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER, OrderNotes ...
    (microsoft.public.access.queries)
  • Re: An efficient way to read data from excel
    ... Do you have some URLs for SQL documentation specific to this task? ... Administrator Drivers tab on my computer? ...
    (microsoft.public.scripting.wsh)
  • Re: Scanned Doc to OCR to Indexed SQL DB
    ... I'd suggest looking into SQL Server's full-text search capabilities. ... There's quite decent documentation in SQL Books Online. ... and uploading them to the their website. ...
    (microsoft.public.dotnet.framework.adonet)