SqlServer-QA.net

Almost a year ago to the day I asked a question on my old blog - how long does *your* CHECKDB take to run? Well, I had a bunch of replies but I never got around to posting the results. I was reminded of this recently so threw together some graphs of the results. I've plotted database size against run-time of DBCC CHECKDB, for a number of ...

While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL Server 2008. We touch on a ton of different features (look at the number of Categories I've tagged this with!) and have a bunch of laughs along the way - check it out here. PS There's been a ton of ...

This is a subject I posted about last year on my old blog but it came up at SQL Connections last week several times so I want to repost it for those who’ve just started following my blog. There's only one time when you should be trying to work out how long a CHECKDB is going to take - when you're planning your regular database ...

As I mentioned in a previous post, one of the new features for database mirroring in SQL Server 2008 is log stream compression. There's a good explanation of what this is (along with some example workloads and performance graphs) on the SQL Customer Advisory Team blog so I'm not going to duplicate all that here. Basically, ...

Disaster recovery isn't just theory for most businesses--it's a harsh business reality. Improve your own disaster recovery efforts today and learn from real-life disaster survivors. Make sure that your plan is ready before a disaster strikes--download this free white paper today!

WEBCAST: Strategies for Creating Effective eDiscovery Policies Discover the emerging best practices for eDiscovery and learn about integrating business, legal and compliance needs with effective IT and storage strategies. View today PODCAST: 9 Biggest Mistakes for eDiscovery..and How to Overcome Them Mistakes involving eDiscovery can cause ...

Q&A with Bill Peldzus - Devising a Disaster Recovery Plan These days, keeping data safe and available should be a top priority in your organization. The possibility of your data being corrupted or ruined by a catastrophe is a real possibility and it is crucial to have a disaster recovery plan in place. This video Tech Talk provides an ...

The highest rated technical articles published by SQL Server Central, covering every aspect of SQL Server development and administration. Get your copy of this Volume3 from here.