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,
We’re sitting here in St. Pete Beach in Florida visiting some of Kimberly’s family and having some sun-kissed R&R before heading back up to Seattle
Over the weekend there was a question on one of the internal aliases at MS: how can I tell what percentage of a database has
While I was at Microsoft, I wrote some code in the Storage Engine to very easily return all the IAM chains/allocation units (see this post
A couple of weeks ago I blogged about the three tracks of the SQL Server 2008 JumpStart course that SQLskills.com taught internally for Microsoft and
This post is based on one from my old MSDN blog but the topic has come up a few times in recent days so I
This is a post I’ve been meaning to do for a while – detailing some of the problems you can run into when using database
Back in October 2007 I blogged about partition-level lock escalation in SQL Server 2008 (see here) and I promised to do a follow-up once
I came across an interesting bug in Management Studio in the latest Katmai CTP today – when a connection disconnects from a database, SSMS doesn’t
Ok – so we did more partying than we thought so blog posts have been a little sparse this month, but here’s one to end
This is a question I was sent a week or so ago – if a table is truncated inside a transaction, what protects the integrity
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
I’ve been involved in a few conversations today that have highlighted some big misconceptions about how backups work. I’d like to use this blog post
After posting last week about a BACKUP feature that I don’t like (WITH NO_LOG – see here), I thought I’d do a quick post this
This has come up several times over the last few days, and is something that Kimberly and I discuss (and deplore) when we lecture –
This is another question that came up on the Disaster Recovery forum on MSDN. Paraphrasing – ‘ I have a backup file containing full backups
Over the years I was in the Storage Engine team I saw a lot of concern on the various forums about the ghost cleanup task.
Here’s a really interesting question that was in my search engine logs yesterday – if I have a transaction that runs and completes while a backup
Whenever I’m discussing index maintenance, and specifically fragmentation, I always make a point of saying ‘Make sure the index is being used before doing anything
I mentioned this in my Anatomy of a page post – its a common misconception that records in an index are ALWAYS stored in 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’
(Check out my online training courses: SQL Server: Detecting and Correcting Database Corruption and SQL Server: Advanced Corruption Recovery Techniques. We can also help you with
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
This week I’m going to post a bunch of info on the basic structures used to store data and track allocations in SQL Server. A
This was a question from the MSDN Disaster Recovery forum I started while I was at Microsoft. I have a 600 gig database that has
One of the great things about the blog engine we use is that it shows all the search engine queries that led to someone clicking
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
This was originally posted as two posts on the SQL Server Storage Engine site. It was very popular so I’ve combined the two posts together
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.