Understanding SQL Server Behavioral Pattern by @pinaldave