Microsoft SQL Server 2012 High Perfo..., Ben–gan, Itzik
Author:Ben-gan, Itzik. Apply powerful window functions in T-SQLand increase the performance and speed of your queries Optimize your queriesand obtain simple and elegant solutions to a variety of problemsusing window functions in Transact-SQL.