SQL Server's server cursor model is a critical tool to many application writers.  Fast_forward cursors are very popular as an alternative to read_only forward_only cursors, but their inner workings are not well-publicized.  So I thought I'd give it a go.

A server cursor is a cursor managed by SQL Engine.  It consists of a query execution and some runtime state, includi