Post reply

sql server 2000 and sql server 2000 64 bit

  • April 25, 2005 at 5:36 am

    #87300

    What is the difference between sql server 2000 and sql server 2000 64 bit.

    How can i find out which one i am using?

    Kindest Regards,

    Pavas

    Dream The Dream
    Explore the World
    Experince The Exhilaration

  • April 25, 2005 at 9:47 am

    #554634

    Select @@version on our 64-bit server results in the following

    Microsoft SQL Server  2000 - 8.00.760 (Intel IA-64)

     Feb  6 2003 16:07:24

     Copyright (c) 1988-2003 Microsoft Corporation

     Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: )

    If you don't see a 64-bit tag on yours then you're not using the 64-bit version

    The difference between the 2, good questions, the main benefit of the 64-bit version allows much more memory to be addressable by SQL server no need to enable AWE memory.  They also cost a hell of a lot more

    We've been using ours for the last 6 months and the performance is much better than we initially expected it to be.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply