-
Unboxing MS SQL Server 2012 – The new analytic functions
As mentioned in my previous blot post, SQL server 2012 comes with 8 new analytic functions: LEAD LAG LAST_VALUE FIRST_VALUE PERCENTILE_CONT PERCENTILE_DISC PERCENT_RANK CUME_DIST All the new analytic functions work with the window functions I described earlier in this blog series, and calculate an aggregate in the given window. Let’s start by looking at the… Continue reading
-
Monitor the process of long running SQL queries like DBCC SHRINKDATABASE
When a query runs a little longer than I would expect, I sometimes starts to get nervous. Especially in the cases, where there is no status telling me when it will finish; Like for instance when I run a shrink database cmd. You can get information about the queries running like this. Especially the percent_complete… Continue reading
-
Unboxing MS SQL Server 2012 – The new window functions
SQL server 2012 comes with a new set of window functions and analytically possibilities, which I will look into in this blog post. Prior to 2012 Prior to the 2012 version, windows functions were also possible. The syntax looked like this: Ranking Window Functions < OVER_CLAUSE > :: = OVER ( [ PARTITION BY value_expression… Continue reading
-
Unboxing MS SQL Server 2012 – Installing the database server and the Adventure works databases
The new MS SQL server version 2012 was released not so long ago. With this article series, I will log my first experiences with it, regarding installation and setup, new features, look and feel etc. First things first. Let’s install it. If you don’t have a developer edition in you company, download a trial version… Continue reading
