CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete
(I’m actually on-stage here at TechEd doing the DAT track pre-con with Kimberly – she’s on now until lunch so I’m catching up on forum problems…)
(I’m actually on-stage here at TechEd doing the DAT track pre-con with Kimberly – she’s on now until lunch so I’m catching up on forum problems…)
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
This is a really interesting question that came up in the Microsoft Certified Architect class I’m teaching at present – if a database has torn-page
One of the drawbacks of not being in the SQL team at Microsoft any longer is that I don’t know about all the undocumented features
Well this one is well overdue and I’m in the middle of writing a class where I want to reference this blog post –
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
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
In one of the sessions Kimberly and I taught this week at SQL Connections, we discussed how to choose efficient data-types – I’d like to
[Edit 8/25/2013: The tool referenced in this post is no longer available.] During SQL Server 2005 development I did a comprehensive rewrite of the Books
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.
I’d like to kick off the Indexes From Every Angle series this evening by re-posting some articles from my old blog. Both of these topics
I mentioned this in my Anatomy of a page post – its a common misconception that records in an index are ALWAYS stored in the
This is a combo from some previously posted material, with some more DBCC PAGE output thrown in. IAM pages An IAM (Index Allocation Map) page
This one’s a quickie. In the previous post I explained about database pages – their structure and some page types. Now I’d like to explain
Next up in the Inside the Storage Engine series is a discussion of page structure. Pages exist to store records. A database page is an
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
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.