THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rick Heiges

News about SQL Server and the SQL Server Community

SQL Server 2000 Still Strong, but Diminishing

I presented a webcast on Wednesday on SQL Server Consolidation.  As with many of my sessions (both physical and virtual), I like to ask several questions.  This is NOT scientific, but it is anecdotal.

Poll Question #1:  Do you have SQL Server 2000 STILL running in production in your organization today?  YES = 70%, NO = 27%, UNSURE = 3%

Poll Question #2:  Which Version of SQL is most prevalent today in your organization?  2005 = 60%, 2000 = 38%, Unsure = 1.8%, 2008 = .2%


As one would expect, the numbers continue to trend downward for SQL Server 2000, but I am still amazed at how widespread it is at 70%!

SQL Server 2000 is a fine data platform, but 2005/2008 is better.  Most of the SQL Server 2000 that I see running out in the "wild" is due to a third party vendor who has not invested in upgrading the back-end and does not support running the DB in '80' compatibility mode or they also require a client-side upgrade which could be a huge cost for customers.  Are ISVs the big road block to moving away from SQL Server 2000?


Published Friday, April 24, 2009 4:48 PM by RickHeiges

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



david wei said:

3rd party vendor is the reason; I recently found a upgrade failed because they use the following code:

select colA, colB from tableA holdlock

This prevents me upgrading the database to 90 comatibility mode, (sql 2005 requires with (holdlock)). Who will pay the cost for changing their code?


April 24, 2009 5:42 PM

AaronBertrand said:

Another roadblock is, it ain't broke, and software assurance no longer applies (or they never had it in the first place), so why spend money on new licenses to "fix" something that will just keep working as is?

I'm with you, by the way; I shudder every time I have to deal with a 2000 instance.  But I have to agree that if there is no compelling reason to upgrade, then they shouldn't feel like they have to.  I know people that drive their cars into the ground, and it's pretty much the same mentality at play here.

April 24, 2009 9:10 PM

Leave a Comment


This Blog


Privacy Statement