SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A Bit About 64-bit


A Bit About 64-bit

Author
Message
RSP
RSP
SSC Eights!
SSC Eights! (936 reputation)SSC Eights! (936 reputation)SSC Eights! (936 reputation)SSC Eights! (936 reputation)SSC Eights! (936 reputation)SSC Eights! (936 reputation)SSC Eights! (936 reputation)SSC Eights! (936 reputation)

Group: General Forum Members
Points: 936 Visits: 623
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rpearl/abitabout64



Antares686
Antares686
SSC-Forever
SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)

Group: Moderators
Points: 49914 Visits: 803
Just purchased a 64bit intel processor and plan to test SQL on it to see if I can tell a difference. But other than memory support I don't see much (at least for me) at this time. I do like the point you make about it may compensate for bad coding but that is the way it has always been. mask the issue with a more powerful solution instead of fixing the root cause. Eventually 64bit will get out-classed by the level of poor work done and we'll move on again.



Stevie T
Stevie T
Old Hand
Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)

Group: General Forum Members
Points: 339 Visits: 95
Interesting read. I am quite agnostic in terms of SQL Server and Oracle - both serve their purpose. Cost wise SQL Server hands down. Oracle for high-end performance.

In terms of 64-bit - I disagree with some of the points though. Increased memory will not compensate for lack of index functionality choice (i.e. Bitmap indexes, joins etc) nor partitioning at a transparent table level (as in Oracle with RANGE partitioning). Until SQL Server has that they will lose the large scale 200GB+ warehouse discussion - IMHO



Tatsu
Tatsu
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3198 Visits: 307
As much as I love SQL Server it has dropped in the TPC scores since that MS article was published in 2003. SQL Server 2005 is in the top 10 in all areas except the 10TB TPC-H (ad-hoc/decision support) and only holds the #1 position in the 100GB TPC-H.

It is possible that the hardware used for the tests is the primary factor but I haven't looked into it in a lot of detail. I would like to see comparisons of the top DBMS platforms running on the same hardware.

Bryant E. Byrd, BSSE MCDBA MCAD
Business Intelligence Administrator
MSBI Administration Blog
Philippe Cand
Philippe Cand
Mr or Mrs. 500
Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)

Group: General Forum Members
Points: 514 Visits: 294
This article as well as other articles on the topic specifically speak about Itanium processor.
I would like to know if one can expect similar behavior on an Opteron machine.

I also have a question for the guys who have a 64 bits SQL and need to run ssis packages that pull data from Oracle 8 or 9i using either oledb for oracle or ado.net oracle data providers.
Did anyone get this to work and how?

Thanks,
Philippe

BI Guy
lindaflor
lindaflor
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 153

Download and install the oracle 64 bit driver (v10.2.0 i think) onto your sql server machine.

On your client machine\workstation install the Oracle 10g 32 bit driver (v10.2.0)

This will work as we have a dev team that connects to oracle and pulls it to Sql Server.

Don't use the Oracle 9i drivers as SSIS BIDS enviroment does not like them





bbellrose
bbellrose
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 18
I just read the article. Wow he should work for MS. I currently run both SQL server 2005 64bit EE in a cluster and Oracle 10g RAC on Solaris. SQL Server can't hold a candle to Oracle.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search