This is part ten in a series on window functions in SQL Server. The Need for Speed SQL Server typically operates in row mode, which means that an operator processes one row at a time. This sounds inefficient, but tends to work out pretty well in practice. However, something which may work out even better…