Tag Archive

Row Count++

Published on March 30, 2011 By Ahmad Alkilani

RowCount++ is a free SSIS Data Flow component used to natively log record counts processed. RowCount++ comes in handy because logging record counts is not available out of the box. Microsoft’s stock Row Count component in SSIS allows you to save row counts in a variable but doesn’t have the ability to read custom data […]

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

Published on March 26, 2011 By Ahmad Alkilani

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 […]