More TSQL Analytic Functions – PERCENT_RANK
Percent rank is defined as the number of values that are the same or less than the current value divided by one less than the… Read More »More TSQL Analytic Functions – PERCENT_RANK
LAG
SQL Sunday Word Scramble
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… Read More »SQL Sunday Word Scramble
Downloads for this weeks SQL Training
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… Read More »Downloads for this weeks SQL Training
This Weeks SQL Server Queries Training
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… Read More »This Weeks SQL Server Queries Training
SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality
Click on the grid to enlarge, then print it. Find the following words in the grid up, down, left, right, horizontal, vertical, and… Read More »SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality
Happy Birthday SQL Server 2012
It has been a year since SQL Server 2012 released. There were some fun posts on Twitter about the SQL Server 2012 birthday or anniversary.… Read More »Happy Birthday SQL Server 2012
My Top 10 TSQL Enhancements in SQL Server 2012
So far after playing around with SQL Server 2012 there are many new features to SQL. Overall I think my favorites are in the Analytic… Read More »My Top 10 TSQL Enhancements in SQL Server 2012
More TSQL 2012 Analytics PERCENTILE_DISC and PERCENTILE_CONT
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… Read More »More TSQL 2012 Analytics PERCENTILE_DISC and PERCENTILE_CONT
More TSQL Analytic Functions – PERCENT_RANK
Percent rank is defined as the number of values that are the same or less than the current value divided by one less than the… Read More »More TSQL Analytic Functions – PERCENT_RANK
TSQL Analytic Functions LEAD and LAG
SQL Server 2012 introduces 8 new analytic functions. This post will cover 2 of them LEAD and LAG, which can be used to reference a… Read More »TSQL Analytic Functions LEAD and LAG