Post reply

sql 2005

  • September 15, 2008 at 1:42 am

    #190768

    Hi, please let me know what is the difference between, 32 bit and 64 bit sql server editions in sql 2005.

  • September 15, 2008 at 3:12 am

    #871633

    The biggest advantage of 64-bit is the ability to directly deal with larger amounts of memory.

    Another big advantages is the ability to consolidate 32-bit database servers in a bigger 64-bit server which will lower your TCO.

    The 64-bit architecture provides also advanced parallelism and threading.

    PSA

  • September 15, 2008 at 3:12 am

    #871634

    This has only to do with the CPU installed on your server. All the MSSQL operations are equal. For an application which uses MSSQL, there's no difference between 32 and 64bit.

    The big advantage of 64bit CPU is they can handle more memory (no AWE tricks). There's a lot documentation about the advantages about 64bit.

    Wilfred
    The best things in life are the simple things

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

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