Continuing on the TSQL 2012 Analytic Series now on to the CUME_DIST function SQL Server 2012 introduces another new analytic function.  The Cumulative Distribution Function CUME_DIST()  refers to the probability that the value of a random variable falls within a …

More TSQL 2012 Analytics CUME_DIST – Cumulative Distribution Read more »

In today’s digitally-driven business landscape, ensuring efficient database management is paramount. It’s the backbone of smooth operations, enabling optimal user experience and robust business processes. With this in mind, Stedman Solutions presents the Database Health Monitor, a comprehensive tool that …

Boost Your Database Performance with Stedman Solutions’ Database Health Monitor Read more »

When it comes to managing databases, every second counts. The health of your database can mean the difference between a smoothly running operation and countless hours spent troubleshooting performance issues. The ability to closely monitor, diagnose, and optimize your databases …

Unlocking Database Performance: Database Health Monitor by Stedman Solutions Read more »

After the last post on Cumulative Distribution Function (CDF) or as it is known in TSQL CUME_DIST(), I realized that although I showed how to use it, I didn’t really explain what it means, or when to use it.  That …

Cumulative Distribution Function (CDF) – Analyzing the Roll of Dice with TSQL Read more »