data set size limit

[dougp]

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.