Can someone please hash out for me what the differences are between a 32-bit and 64-bit system? I am going to use the Vista 64-bit and I want to have a clear understanding of it. For example, when I go to download SQL Server Express (just as an example) there are 3 different downloads available:
I would assume the x64 is for the 64-bit system. the SQLEXPR32_x86 is for a 32-bit system, but what is the SQLEXPR_x86 for? What does the x86 stand for? Also, what is going on behind the scenes - is it just different drivers or what?
Thanks for the help