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

Still 32

By Steve Jones,

I was listening to a presentation recently and the presenter talked about some of the restrictions in working with 32 bit SQL Server on 64 bit Windows hosts. Another person joked that any companies still running 32 bit software were way behind the times. I heard a comment that surely everyone runs 64 bit hardware these days, don't they?

Do they? How many servers in large companies are still running on the x86 architecture? I know I have old laptops still running those processors, though I'd like to think that most companies have a hardware refresh rate that's no longer than 5 years, and most laptops and servers would be x86.

The platform architecture, however, doesn't necessarily imply our software has been upgraded to 64 bit. There are problems with various drivers that won't run under 64-bit architectures. Excel is often a problem as SQL Server moves to 64-bit versions. There are 64-bit drivers, but the change, testing, etc. effort for many companies may not be worth pursuing. It can be annoying for us data professionals, but it's a valid business decision. The same argument often applies to those companies running SQL Server 2000 (or older versions).

Five or six years ago I heard a presenter that worked for a large Fortune 100 company say that their policy was for applications to last ten years. That included the hardware and software, since the cost of change, whether through new software or major upgrades, was significant. With many companies still running SQL Server 2000, I suspect that many companies have a similar, unofficial, policy. 

I don't know whether the majority of software we use in our careers is 32 bit or 64 bit, but I am sure that we will have to deal with the former for years to come. You can complain about it, but you better learn to work with it.

Steve Jones

The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there. Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

You can also follow Steve Jones on Twitter:

Total article views: 100 | Views in the last 30 days: 1
Related Articles

Software Giants

Microsoft is the largest software company in the world. What does this mean for SQL Server? Steve Jo...



A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...


SQL Server Podcasts

Great news, I have decided to do some podcasts on the fundamentals of SQL Server, my aim is to help....


Contracting question - Left old company, but still provide support.

I left my old company but I still provide my services via contracting.


Serverless Software

Today Steve Jones talks about the future of software development and how it might not require develo...