In Recovery...

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!

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 […]

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!

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 […]

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 […]

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!

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 […]