I know that one of the big differences between custom and default paging is how the returned dataset get parceled out.

In particular, I know that for default paging, the entire returned dataset is used for each page, but only the page selected by the user is displayed in the DataGrid.

What I need to know is if the entire contents of the dataset are being pushed to the client, or is the entire dataset being returned into memory on the webserver from the SQL server, and only the page requested being pushed to the client?