Inside the Storage Engine: Proof that records are not always physically stored in index key order
I mentioned this in my Anatomy of a page post – its a common misconception that records in an index are ALWAYS stored in the
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
In SQL Server 2005, queries over partitioned tables use a single-thread per partition. This can cause performance problems under certain circumstances: On systems with many
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
November’s going to be a busy month for Kimberly and I! Hot on the heels of SQL Connections in Las Vegas is
(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’
SQL Server supports lock escalation – when the server decides to move from a large number of row or page locks on an object to a
(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
Ok – I’m on a roll today so to finish off I’d like to repost some info about database mirroring failover types (including how you
Part of the improvements to database mirroring in SQL Server 2008 are the addition of 10 new performance counters under the Database Mirroring Performance Object.
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 hottest features in SQL Server 2005 is database mirroring, and it’s helped many companies implement successful and relatively inexpensive high-availability strategies. In
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
Over the next few months I’ll be blogging a lot about new features that are coming in SQL Server 2008 for DBAs and ITPros. First
The Fall conference season is on us again! Building on the great reaction to our co-presented Database Maintenance workshop at SQL Connections in Orlando,
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
Now that I have a little more time on my hands I’ve been jumping back into some of the online forums. Last summer I posted
One of the comments I received recently is below: Hi Paul, If the corruption happens to be related to I/O Erros and there is nothing
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
Well, now I’m no longer a ‘Softie’. It feels a little strange after having been on the SQL team for 8.5 years but I’m really jazzed
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.