Monthly Archives: January 2012

Analytics Function in SQL Server 2012

Posted on January 27, 2012 by randheerparmar

Analytics quite a buzzword these days in the market. There are few tools in market which do analytics such as SAS, SPSS, R language. My expertise is in SQL Server and trying to relate analytics with SQL Server and many … Continue reading →

Posted in SQL Server 2012 | Leave a comment

Aggregate Transformations

Posted on January 20, 2012 by randheerparmar

Aggregate Transformation: Aggregate transformation is used for basic aggregation as in SQL such as count distinct, group by.  Advance Window Providing the number of distinct values, exact or approximate, optimizes performance, because the transformation can preallocate an appropriate amount of … Continue reading →

Posted in SSIS Issues and Resolution | Leave a comment