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
3,676 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
5,040 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
5,038 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,316 reads
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Hi Everyone! I have a problem with a SQL Server 2017 with dbmail. I...
Hello, Kindly guide me with the following code in T-SQL. I need to only...
Comments posted to this topic are about the item New Stuff Can Be Scary
Ask SSC