Bug: Error: 3449 and server restart during DBCC CHECKDB
This is a quick post to let you know about a bug that a few people are hitting when running DBCC CHECKDB. The symptoms are
Menu
This is a quick post to let you know about a bug that a few people are hitting when running DBCC CHECKDB. The symptoms are
I’ve just heard from our good friends at Pluralsight that our two latest online training courses are now live and available for watching! My latest
My latest Pluralsight online training course went live today: SQL Server: Detecting and Correcting Database Corruption It’s 4 hours long and is the first in
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
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:
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.
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
[Edit 2016: The team ‘fixed’ the problem in SQL Server 2016 by skipping consistency checking these indexes unless WITH EXTENDED_LOGICAL_CHECKS is used.] It’s no secret
There’s cool mechanism that the buffer pool has called disfavoring, that sometimes kicks in to prevent pages from a different database being flushed from the buffer pool
About a month ago I kicked off a survey with some code to run to figure out how many log files your databases have (see
In my previous post I explained how the sp_configure settings are stored in a special page in the master database called the CONFIG block. Sometimes
Earlier today I blogged on our SQL Server Pro magazine blog about false-alarm corruptions you will *definitely* see if you restore a backup of the
Back in 2009 I ran a survey about methods of running consistency checks. I recently re-ran the survey to get a better idea of the
Three years ago I ran a survey about consistency checking methods. A lot has changed since then, including database sizes, 24×7 operations, and a lot
I bet you'd love the answer to be "SQLskills.com"? Well now it can be. Over the last few months some of our clients for whom
A few weeks back I kicked off a survey asking whether you have SharePoint in your SQL Server environment at all. Here are the results:
This question came up on the #sqlhelp tag on Twitter today, and it's something I'm interested in too: what percentage of SQL Server environments include
As you may know, I've been teaching the SQL Server portion of the SharePoint MCM since it started. The old database maintenance whitepaper for SharePoint 2007
(Check out my Pluralsight online training course: SQL Server: Index Fragmentation Internals, Analysis, and Solutions.) Back in April I kicked off a survey where I asked
In this survey I'd like you to run some code and then send me the results (and I'm sure someone will put together a PowerShell
A few weeks ago I kicked off a survey about tempdb configuration – see here for the survey. I received results for more than 600
Last week I kicked off a survey about the size of the largest single SQL Server database in your company – see here for the
In my survey this week I'd like to find out how large the largest single SQL Server database is at your company (how much space
Last week I kicked off a survey about network latencies and database mirroring. See here for the original post. Here are the results of the
Happy Holidays! Back in January I ran a special offer on our new (at the time) auditing service, and as the holidays approach I'd like
The November 2010 edition of TechNet Magazine is now available on the web and contains my latest feature article. In this article I give my top-10
The May edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
For about 6 months we'd bee trying to hook up online with SharePoint MVP Hilton Geisenow for an interview but unfortunately the bandwidth to South Africa is
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
Way back in the mists of time, at the end of the last century, I wrote DBCC SHOWCONTIG for SQL Server 2000, to complement my
Back in January I offered a promotion as a way of introducing our maintenance/operations auditing services. Now I've completed a bunch of them, with some
One of the perennial problems facing both experienced and involuntary DBAs is how to tell whether a database is really in the Full recovery model
Here's an interesting bug that surfaced recently, first reported by Bryan Smith on the MSDN disaster recovery/HA forum three weeks ago. One of the mechanisms I
This survey is based on a suggestion from Jonathan Kehayias (blog/Twitter). In this survey I'm asking two questions: When you're designing/implementing a database, do you
Here’s a question that came up recently: if I’ve upgraded a database from SQL 2000 or before, how can I tell if the data purity
A long time ago, in a blog post far, far away (well before I went offline in July) I kicked off a weekly survey about
In this week's survey I'd like to know how often you run consistency checks on your *most critical* production database, regardless of *how* you run
In last week's survey I asked how you manage the size of your database *data* files – see here for the survey. Here are the
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
In this week's survey I'd like to know how you manage the sizes of your database *data* files (remember we've already done log file size
There are a couple of issues that I’ve heard of in the last few weeks (one while onsite at a customer) and I think they might bite
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.