64 bit sql

NavStudent
NavStudent Member Posts: 399
edited 2007-03-31 in SQL General
Hello I had a question about 64 bit sql.

I know that the application finsql.exe is 32 bit. but the sql server executable runs on 64 bit executable.
Does sql stores the (indexes) in 64 bit?

Ofcourse the data is stored in 32 bit, otherwise if you pass 2.1 billion entry no in GL Navision client won't accept it.

So will navision client every be released in 64 bit?
will the service tier in 5.1 be in 64 bit?

thanks
my 2 cents

Comments

  • bbrown
    bbrown Member Posts: 3,268
    It is the same database whether you run 32 or 64 bit SQL. 64 bit does not change anything about the data storage. The advantages to 64 bit are on the processing side as it provide for a larger set of system resources. There is a SQL 2005 whitepaper titled "Advantages of a 64-bit Environment". It gives a good overview of the advantages of 64 bit systems.
    There are no bugs - only undocumented features.
  • NavStudent
    NavStudent Member Posts: 399
    thanks. i found the document.
    my 2 cents