This may be related to how long Postgres has had support for various window functions, vs. MSSQL only gaining equivalent support in v2012 (AFAIK). Also, the var

This may be related to how long Postgres has had support for various window functions, vs. MSSQL only gaining equivalent support in v2012 (AFAIK). Also, the various query optimization struggles older versions of MSSQL had. http://sqlperformance.com/2013/03/t-sql-queries/the-problem-with-window-functions-and-views http://sqlperformance.com/2013/03/t-sql-queries/the-problem-...