I know there is a setting for the size limits for uploaded data.
Is there a setting for the size limit for data sets, either per data set or per user? Where is this configured?
I have a situation where, sometimes, for one data set, SQL Server is taking a very long time (20+ hours) and filling up the hard drive with tempdb (often causing SQL Server to become unresponsive) and blaming a specific query (same data set every time it happens). But other times the query succeeds and the data set populates in 8 minutes without any affect on tempdb. I'm wondering if I'm hitting some limitation in Cognos and it's just not responding to SQL Server.