Survey: what’s the newest version of SQL Server that you have in production

In this survey I’d like to know what the newest 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 (rather than just evaluation purposes). I’ll report on the results next week. Thanks!

More businesses than you think are still using SQL Server 2000

Last week I kicked off a survey asking what is the oldest version of SQL Server you have in production. Here are the results: I’m actually quite surprised. While I expected to see a┬ásizable percentage of businesses still with SQL Server 2000 in production, I didn’t expect it to be almost half of all respondents […]

Survey: what’s the oldest version of SQL Server you have in production?

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!

Chicago classes are all sold out, don’t wait to register for London

As of this afternoon all eight classes we’re doing in Chicago in April/May are sold out – that’s 160 people we’ll be training! The reason for this post is to remind those of you who are planning to come to one of our London classes in June that they’re all more than half full already […]

Easy automation of SQL Server database maintenance

A while back I kicked off a survey asking what mechanism you use for running your regular SQL Server database maintenance. Here are the results: The “Other” responses were: 7 x “A combination of maintenance plans generated from SSMS wizard and a home-grown index maintenance script” 5 x “Combo of own and modified scripts of […]

Survey: what mechanism do you use for regular database maintenance?

I haven’t done any surveys this year and I’d like to get back into doing one every week or so for the next few months. In this survey I’d like to know what mechanism(s) you use to perform your regular database maintenance. I’ll editorialize the results in a week or so. Thanks!

DBCC CHECKDB scalability and performance benchmarking on SSDs

Back in February I ran a bunch of performance tests of DBCC CHECKDB on SSDs, to evaluate the effects of degree-of-parallelism (DOP) and various options and traceflags, and now I’m finally getting around to presenting the results. Make sure to also read the recent┬ápost where I talk about the detrimental effect of computed-column indexes on […]