It is a very popular database development task of loading data from the database to files directly. But how does it happen? Is it implemented immediately or the data is stored in memory first and transited to files later? Which event causes data transfer to transactions registration table and to files? Let’s see how it goes.

This article is dedicated to the operator APPLY, and more specifically its type CROSS APPLY. This statement was first introduced in SQL Server 2005, but unfortunately many have not learned how to use it, maybe it's because of the fact that the BOL (SQL ServerBooksOnline) this operator is not well and has a very "dry" examples of its use. In this article, I'll show some interesting demonstrations, where the operator can come in handy.