In Part 1 of this article we looked at a specific use case (probably exaggerated) that gave us an idea about how CPU and IO performance might be affected by a bad page split. We continue this analysis looking at what really happens to the data on the leaf pages of a clustered index with […]
2020-07-02
4,102 reads
2015-05-11
1,586 reads
2012-12-26
1,795 reads
My biggest fear when my book went into production was that any factual errors...
Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking...
By Steve Jones
Today’s coping tip is to listen to a piece of music without doing anything...
What could be the most surprising fact for you in the morning? It is...
Hi, I've been tasked with finding out why we've been unable to patch the...
Hi everyone, So I have a ssis package in which I download a excel...
Ask SSC