Regarding mssql storage, if there is only one large database on the server, then managing space is relatively simple, just give it plenty of space and then initialize the data and log files to fill what's available. But what's really problematic is when there are several large databases sharing the same log and data drives, and because of end user patterns, each can grow unexpectedly. That is perhaps the scenario where creating a stub file can come in handy.