Category: Analytic TSQL

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

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 is where this example comes in. First lets take an example that generates simulated dice rolls.  What are the odds …

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

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

SQL Server – TSQL Analytics Word Search   Find the following words in the word scramble above. TOP RANK DENSE_RANK ROW_NUMBER NTILE OVER LAG LEAD FIRST_VALUE LAST_VALUE PERCENT_RANK PERCENTILE_DISC PERCENTILE_CONT CUME_DIST PARTITION ROWS PRECEDING FOLLOWING UNBOUNDED   Download the Printable PDF of the Word Search. See Also TSQL Queries – Using NTILE TOP, Ranking, NTILE, and Aggregate Functions TSQL Analytics FREE …

SQL Sunday Word Scramble Read more »

By Posted on Posted in Analytic TSQL, Classes No Comments Tagged with , , ,

  Continuing our weekly SQL Query Training for the 70-461 exam preparation, at Steve Stedman, sharing this weeks class with the world. Free SQL Query training.     Here is the video of the training on TOP, Ranking, NTILE, and Aggregate Functions today. The first half was presented by Aaron Buma, and the second half I presented. The following topics …

TOP, Ranking, NTILE, and Aggregate Functions Read more »

By Posted on Posted in Analytic TSQL, Classes, Query Certification No Comments Tagged with , , , ,

As posted earlier. This weeks SQL Queries training for the 70-461 certification will be on Thursday at 9:00am (US pacific time). Please join the live broadcast on Google On Air Hangouts, or catch the recorded version on myYouTube Channel. Aaron Buma will be presenting the first half of the session and I will be presenting the second half. We will …

Downloads for this weeks SQL Training Read more »

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

SQL Server 2012 adds many new features to Transact SQL (T-SQL).  One of my favorites is the Rows and Range enhancements to the over clause. These enhancements are often times referred to as the windowing functions. Want to learn more about the windowing functions? Check out this aggregation class that I have created: Overview:ROWS PRECEDING, FOLLOWING, UNBOUNDED, refers to the …

Rows and Range, Preceding and Following Read more »

By Posted on Posted in Analytic TSQL, Classes, Code Camp, CTE, TSQL 2012 No Comments Tagged with , , ,

What a great day at  Code Camp today. Click here to download the slides and sample code from the presentations. The first presentation that I attended was  Accelerating your Development Workflow presentation by Ian Davis.  What a great presentation, it touched on the lean and agile development processes, it was very well done. The next one was a PowerShell presentation that …

Home after Seattle (Redmond) Code Camp 2012 Read more »

By Posted on Posted in Analytic TSQL, Classes, Code Camp, CTE, TSQL 2012 No Comments Tagged with , , , , , , , ,

I am headed to Code Camp in Redmond WA today.  I ended up with 3 sessions that I will be presenting, and I am really looking forward to the day. I am looking forward to attending the Accelerating your Development Workflow presentation by Ian Davis. Here is what I am presenting… What’s New in TSQL 2012 This is the first time that …

Code Camp in Redmond Today— Read more »

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

Here are the sessions that I will be presenting at Code Camp in two weeks.. What’s New in TSQL 2012 This is the first time that I will be presenting this one.  Its going to be a lot of fun working with the new features in TSQL 2012. Unleashing Common Table Expressions in SQL Server This will be about the …

Sessions for Code Camp in 2 weeks Read more »

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

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 is where this example comes in. First lets take an example that generates simulated dice rolls.  What are the odds …

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

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 »