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,551 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,813 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,281 reads
By Daniel Janik
Recently I ran into an error when trying to copy a small database bacpac...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing...
Does anyone know of any existing script that would allow me to list all...
Hello, How to delete backups in blob storage from azure sql server VM to...
Ask SSC