Yesterday in class we had a discussion around the conceptual problem of reconciling the fact that SQL Server does set-based operations, but that it does them in query plans that pass single rows around between operators. In other words, it uses iterative processing to implement set-based operators. The crux of the discussion is: if SQL [&]

The post Reconciling set-based operations with row-by-row iterative processing appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/2s085jr2QMM/