Your tech lab just changed forever
The VMware Users Group VMUG just announced a partnership with VMware, called the EVALExperience, to offer VMware technology pre-production 365-day licenses...
2015-01-21
553 reads
Blog Posts
A Reason To Smile! - Deep Dives II
Over this past weekend, SQL MVP Kalen Delaney sent an inspiring note to the MVP email thread, and I wanted to...
2015-01-20
1,960 reads
Collation Conflicts
I have recently seen some “bad plans” being generated by the optimiser and from investigation, the cause came down to...
2015-01-20
1,710 reads
Common Table Expressions Are Not Tables
There’s power in naming things. Supposedly some types of magic are even based on knowing the correct names for things....
2015-01-20 (first published: 2015-01-14)
8,478 reads
It’s a Problem When a SysAdmin Can’t Log In
I showcased a demo recently that looked at a potential issue with an application where a user used a simple...
2015-01-20 (first published: 2015-01-12)
6,537 reads
Outlier Detection with SQL Server, part 3.3: The Limitations of the Tietjen-Moore Test
By Steve Bolton
…………The Tietjen-Moore test may have the coolest-soundest name of any of the outlier detection methods I’ll be surveying...
2015-01-20
1,275 reads
SQL Script to find the databases size
Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used...
2015-01-20
592 reads
SQL Script to find the list of all the jobs failed yesterday
One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below...
2015-01-20
2,451 reads
SQL Script to find the tables created from a given date
Below is the SQL query which can be used to find out the tables which are created or modified on...
2015-01-20
652 reads
SQL Script to search stored procedures containing a given text
Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used...
2015-01-20
666 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
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