In this survey I’d like to know what the oldest version of SQL Server is in your environment – it has to be an instance that’s being used for a production workload in some way (even just occasionally).
I’ll report on the results next week.
Thanks!
In the previous Curious Case I described an issue Jonathan had at a client with very long IAM chains, and the circumstances leading to it.
(The original version of this post first appeared on the now-deleted SentryOne blog at the start of 2022.) One of the most fundamental concepts in
(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the
(This is from the Insider Newsletter that I sent out earlier today…) Back in early 2023 I wrote a long blog post about my struggles
This is a case that happened on a client system last year: occasionally a common query on a tiny table appeared to ‘hang’ and had
(TL;DR; Video trailer for the new course is here.) Joe’s next course, AIVSP: Vector Search in Practice, is now available! This online course builds on AIVSE:
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.
10 thoughts on “Survey: what’s the oldest version of SQL Server you have in production?”
One of mine is SQL Server 2000 running a database in 6.5 compatibility mode, but I voted SQL Server 2000.
I voted for SQL Server 2005, but several of the databases on that server are running in SQL Server 2000 compatibility mode.
2005 is the NEWEST version we run and yet they still complain about performance. SMH
Where do we take these surveys? I’m just not seeing a link or anything.
The survey is embedded in the post. Shows up on Chrome and IE – older versions of browsers might not show it.
I’m runnin’ Interweb Explorer 10 on Winders 8.
Seriously though I’m on IE 10. Hmm…
I just tried Firefox 17, and there’s no survey there either.
Is it provided by a 3rd party and embedded in a iframe or something like that? Wonder if our network security hardware is blocking it.
Yup – that’s exactly how it’s set up. My guess is your security. Try at home to see if you can see it?
It worked at home. However, the bottom half of the Vote and Results buttons are cut off in IE 10.
http://imgur.com/gallery/yMkRc
;-)
Yup – IE has all kinds of weird problems. I moved to Chrome earlier this year because I was sick of it. I don’t ever test in IE.
I voted for SQL Server 2005, but several of the databases on that server are running in SQL Server 2000 compatibility mode