I have a company intranet that utilizes a similar set of data across many different pages and many different methods.Speaking in generalities, is it closer to best practice to retrieve a large dataset and filter it for each specific page or method or retrieve many smaller specific sets of data to use?  I cannot really test both approaches, as I would like to pick a design approach from the beginning and use it throughout.  This is for a redesign.  Thanks.
Should I retrieve one large set of data to filter or smaller individual sets of data?
.net;asp.net;sql;sql server