MSSQL partitioning and sp_whoisactive

Partitioned Tables and Indexes in SQL Server 2005

Partitioned Table and Index Strategies Using SQL Server 2008

Who is Active

MSSQL does not support remote scale-valued user define function call.

MSSQL 2008 added new functions merge().