sql server 2000 and sql server 2000 64 bit

• Pavas Malviya

  Ten Centuries

  Points: 1109

  More actions

  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

• Mike Metcalf

  SSCrazy Eights

  Points: 8763

  More actions

  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.