SQL Server

SQL Server Ranking Functions Row_Number(), Rank(), Dense_Rank() and NTIle()

Posted by on March 26, 2011 at 9:28 am

SQL Server 2005 introduced new ranking functions. This article is tailored as an introduction to these functions, difference between them and when to use each and a few examples. Ranking What: The new ranking functions are new internal functions to SQL Server 2005/2008. From MSDN “Ranking functions return a ranking value for each row in [...]

SQL Server Modeling Services – Quadrant and M Overview

Posted by on March 24, 2011 at 7:39 am

Last week I was part of an interesting “call” with Microsoft around SQL Server Modeling Services and what it had to offer. The purpose to get client feedback on the proposition and also provide us with some insight on what it was and where it was heading. First let me clarify that SQL Server Modeling [...]