Does anyone have any experience with optimizing connections to SQL Server? Someone suggested that all views share a single connection for optimization, but if you have two many views sharing the same connection, it may bog down. Also, I've heard of third party tools for managing connections. Is there any rule of thumb here?