Paul S. Randal

In Recovery…

Category: DBCC

Buffer pool disfavoring

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

Explore

DBCC PINTABLE

(Continuing my habit of blogging while Kimberly’s presenting – at least I’m not on stage this time…) In early versions of SQL Server, it was

Explore

IAM page corruption examples

A thread cropped up on SQLServerCentral involving IAM chain corruption (see Inside the Storage Engine: IAM pages, IAM chains, and allocation units for details of IAM

Explore

Imagine feeling confident enough to handle whatever your database throws at you.

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.