Search results for: Analytics

By Posted on Posted in Analytic TSQL, SQL 2012, TSQL 2012 No Comments Tagged with

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 specified range. CUME_DIST  is the function that maps values to their percentile rank in a distribution.  CUME_DIST function calculates the possibility …

More TSQL 2012 Analytics CUME_DIST – Cumulative Distribution Read more »

By Posted on Posted in Classes, SQL 2012, TSQL 2012 No Comments Tagged with ,

Like the other new Analytic functions, PERCENTILE_DISC and PERCENTILE_CONT require the use of the OVER clause. For this example I will be using almost the same revenue table in the sample database that I set up for the LEAD and LAG posting earlier in the week, and the PERCENT_RANK posting yesterday, just a few values changed to show the differences between these …

More TSQL 2012 Analytics PERCENTILE_DISC and PERCENTILE_CONT Read more »

By Posted on Posted in Performance No Comments

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 facilitates effective database management. This July, we are offering a remarkable opportunity: a 25% discount on the Database Health Monitor …

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

By Posted on Posted in Performance No Comments

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 is crucial in maintaining an efficient, productive environment. And that’s exactly where Database Health Monitor by Stedman Solutions comes in. …

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

By Posted on Posted in Performance No Comments

Exploring Sample SQL Databases in SQL Server SQL Server is a robust relational database management system that offers a variety of features for data management, analysis, and reporting. One of the great resources for learning and testing SQL Server capabilities is the set of sample databases provided by Microsoft. These databases are rich with sample data and scenarios, making them …

Exploring Sample SQL Databases in SQL Server Read more »

By Posted on Posted in Performance No Comments

How Critical Is Your SQL Server Performance? Understanding the Impact of Slowdowns In the realm of SQL Server management, performance isn’t just a technical metric; it’s a cornerstone of business efficiency and success. As someone deeply entrenched in the world of SQL Server, I’ve witnessed firsthand the transformative power of optimal performance—and the significant challenges posed by slowdowns. It’s time …

How Critical Is Your SQL Server Performance? Read more »

By Posted on Posted in Performance No Comments

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 facilitates effective database management. This July, we are offering a remarkable opportunity: a 25% discount on the Database Health Monitor …

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

By Posted on Posted in Performance No Comments

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 is crucial in maintaining an efficient, productive environment. And that’s exactly where Database Health Monitor by Stedman Solutions comes in. …

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

By Posted on Posted in Database Health No Comments Tagged with ,

This month brings treats for new Database Health Monitor users and old! Make sure you check back to see what’s released! This month we will announce a Sale on our Database Health Monitor Course When purchased it allow you to connect to 20 servers! New tips on how to use Database Health Monitor Hot key tips to make your job …

Database Health Month! Read more »

By Posted on Posted in Database Health No Comments Tagged with ,

We hope you enjoyed last month’s Common Table Expressions theme and all the video tips and blog posts we released. July we will be focusing on Database Health Monitor and we will be releasing some SAVINGS as well as some TIPS AND TRICKS! So make sure to follow us on social media, sign up for our newsletter or check back …

What’s Coming in July? Read more »