Post reply

32 bit versus 64 bit

  • February 10, 2010 at 6:56 am

    #215549

    Hi All,

    please help me and step by sep explain the features of 32 bit and 64 bit.

    Regards,
    Shivrudra W

  • February 10, 2010 at 7:07 am

    #1116790

    32 bit, can only directly address 4 GB, has to use tricks to use more memory than that.

    64 bit, flat addressable memory of millions of times more than any server currently has.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 10, 2010 at 7:21 am

    #1116803

    Thanks,

    any other features 🙂

    Regards,
    Shivrudra W

  • February 10, 2010 at 7:33 am

    #1116812

    No, the difference between 32 bit and 64 bit is around memory addressing.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 10, 2010 at 10:37 pm

    #1117373

    Yes... more features... but the wrong way...

    I'm not sure if they've fixed the problem yet or not but my understanding is that 64 bit versions cannot use JET drivers... that pretty much kills things like OPENROWSET for spreadsheets and the like.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • February 10, 2010 at 11:18 pm

    #1117386

    Thanks

    Regards,
    Shivrudra W

  • February 11, 2010 at 1:23 am

    #1117423

    Jeff Moden (2/10/2010)

    I'm not sure if they've fixed the problem yet or not but my understanding is that 64 bit versions cannot use JET drivers... that pretty much kills things like OPENROWSET for spreadsheets and the like.

    That's not a 64-bit feature, that's the lack of a 64 bit driver for JET. For SQL (SSIS, Windows, etc) to use a driver, that driver much match the processor 'bit-size' (can't think of a better term) of whatever's using it.

    64 bit Windows cannot use a 32 bit printer driver. 64-bit SQL cannot use a 32 bit data access driver, etc.

    Office 2010 has a 64 bit version, so that should fix the lack of JET (MSAccess) drivers for 64 bit SQL.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 7 posts - 1 through 6 (of 6 total)

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