Do you use SQL Server and are thinking about using Collector to store potentially large amounts and data and pictures?  Check out this article.  Experts from the Ohio Department of Transportation provide a detailed workflow example, with step by step instruction, for using FILESTREAM with Collector for ArcGIS to gather, manage and store extremely large datasets in the best ways possible for performance, management and scalability, in line with current industry best practices.