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
2,867 reads
What's the true and permanent cost of lowering the Fill Factor of an index in SQL Server? It's a lot more than many people think. 9 year SQL Server MVP veteran, Jeff Moden, demonstrates how to calculate the extra space that will be used by lowering the Fill Factor and saved by increasing it.
2019-09-03
4,794 reads
With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]
2019-08-08
4,909 reads
Enhanced version of Index Rebuilt Script originally written by Michelle Ufford, which now includes latest version updates and additional features.
2016-02-17 (first published: 2016-02-04)
1,302 reads
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By John
No, not that kind of volume! Over the past couple of blog posts, I...
I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...
Comments posted to this topic are about the item Managing Stress
Ask SSC