In the last article, we examined fuzzy string matching in SQL Server 2025 with a few new functions. We know comparing strings has always been hard when we don't have great data quality. If we need exact matches, SQL Server works great. However, we often expect users to enter values without typos and know what […]
2026-01-23
1,089 reads
2026-01-21
372 reads
sp_helptext has served SQL Server DBAs for years, but it has its very obvious – and many – limitations: broken lines, missing triggers, no help with encrypted objects, to name just a few. That’s where sp_showcode comes in…
2026-01-21
After years of writing T-SQL a certain way, changing can be tough. When comparing tables for missing rows, developers often use LEFT JOIN.
2026-01-19
2026-01-19
445 reads
2026-01-16
497 reads
Learn why SQL Server shows ‘Invalid object name’ errors and how to fix them.
2026-01-12
2026-01-12
665 reads
2026-01-16 (first published: 2026-01-09)
517 reads
Learn about these new binary encoding and decoding functions in SQL Server 2025.
2026-01-09
2,285 reads
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I was messing around performing investigative work on a pod running SQL Server 2025...
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Planning a wildlife adventure in Pench National Park can be exciting yet overwhelming, especially...
Comments posted to this topic are about the item What is Page Density
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers