Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 When dinosaurs evolve

Author  Topic 

SamC
White Water Yakist

3467 Posts

Posted - 2005-05-26 : 08:11:13
I was wondering how many on this forum are running 64 bit SQL and what the experience has been like...

- How much more costly is it in $$, effort, new problems to address?

- Other than more horses, what problem did 64 bit solve?

- I assume 32 bit is the dominant installation. Any thoughts on the percentage of servers out there running 64 bit?

- Is the adoption rate for 64 bit increasing?

- Is pro wrestling fixed?

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-05-26 : 08:16:00
Shhh, don't say evolve. Rob is in GA, they don't like evolution there



Damian
Ita erat quando hic adveni.
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-05-26 : 08:18:25
HEY HEY HEY, the proper term is "When dinosaurs change over time".

More on that here:

http://www.cnn.com/2004/EDUCATION/01/30/striking.evolution.ap/
http://www.cnn.com/2004/EDUCATION/01/30/georgia.evolution/
http://www.cnn.com/2005/LAW/01/13/evolution.textbooks.ruling/

Sorry about the threadjacking, ask me how glad I am my tax dollars pay that bimbo's salary...and I don't even have kids in the GA school system (thank GOD! love the irony of that) You gotta admit, the GA board of ed. members are their own best example that evolution is not a fact. I'll shut up now.

Anyway, 64-bit gets you one huge plus besides CPU power, and that is memory availability. No more 4 GB limit or AWE extensions. I think Win64 will support 512GG to 1TB of RAM.

We are getting a new AMD 64 bit server at work and will probably go with 32 bit for the time being, but moving up to 64 bit in the software is a huge plus with that architecture, and it'll be essentially free. From the specs I've seen, performance in 64-bit is 50% or better over 32-bit, all else being equal.
Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2005-05-26 : 08:25:04
quote:
Originally posted by Merkin

Shhh, don't say evolve. Rob is in GA, they don't like evolution there


You know you've been programming too long when your first thought is, "Huh? Why would someone doing Genetic Algorithms not like evolution?"
Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2005-05-26 : 08:33:24
I thought SQL Server 2000 (64 bit) was for the Itanic. Don't we have to wait until SQL Server 2005 for something that supports Windows x64 properly?
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2005-05-26 : 10:37:07
Not one response so far of anyone actually running 64 bit...
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2005-05-26 : 10:40:31
quote:
Originally posted by robvolk

http://www.cnn.com/2004/EDUCATION/01/30/striking.evolution.ap/
quote:
If you're teaching the concept without the word, what's the point?" said Rep. Bobby Franklin, a Republican. "It's stupid. It's like teaching gravity without using the word gravity.

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-05-26 : 12:13:02
Eyechart is running 64-bit. I think he might be the only one here in the forums though.

Tara
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-05-26 : 12:24:59
BTW, I think he's discussed it in the Admin forum.

Tara
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-05-26 : 12:28:35
does SQL 64 use all it's power if it's installed on 64 bit CPU with 32 bit windows?
did win64 come out yet??

Go with the flow & have fun! Else fight the flow
Go to Top of Page

jhermiz

3564 Posts

Posted - 2005-05-26 : 13:06:05
no and yes



Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-05-26 : 15:26:28
Maybe interesting....
[url]http://www.sqlservercentral.com/columnists/rpearl/abitabout64bit.asp[/url]

rockmoose
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2005-05-26 : 16:28:11
I'd guess if Graz did a survey on the SQLTeam home page, 99% of the responses would be 32 bit...
Go to Top of Page
   

- Advertisement -