CHECKDB bug that people are hitting – Msg 8967, Level 16, State 216
Before I start, I want to make it clear that you can only hit this bug if you ALREADY have corruption, that it’s quite rare,
Menu
Before I start, I want to make it clear that you can only hit this bug if you ALREADY have corruption, that it’s quite rare,
[Edit: From 2016 SP2 onward, you can use SELECT DATABASEPROPERTYEX (‘dbname’ , ‘LastGoodCheckDbTime’ ); instead] This came up several times during the week so I
In the mail today I received notice that my first software patent has been granted by the US Patent Office :-) (after being filed 3.5
This is a question that comes up a lot – how to run consistency checks on a VLDB? We’re talking hundreds of GBs or 1
In my previous post on interpreting DBCC CHECKDB output, plus in my DBCC Internals session at TechEd IT Forum in Barcelona yesterday, I mentioned there
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
Last week at SQL Connections someone said that CHECKDB’s output is ‘useless’. Given that I wrote CHECKDB for SQL Server 2005 I was only mildly
I’m in the middle of a flight from Washington D.C. to Zurich on the way to Barcelona for TechEd IT Forum and I can’t sleep
(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’
Time for the first post in the Inside the Storage Engine series. I’m going to focus on SQL Server 2005 in this series and I’ll
Quickie this morning – I was surfing some MVP blogs this morning and came across a series of posts by Allen White around using VB Script
On the Storage Engine blog last year I started two series that I got distracted from – one on DBCC CHECKDB and one on fragmentation.
(Check out my online training course: SQL Server: Detecting and Correcting Database Corruption.) In this post I want to describe the two worst things I
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.