Post reply

SSRS report with 17 parameters times out

  • July 4, 2011 at 8:23 am

    #1347885

    quan23 (7/4/2011)

    Aha, I was thinking that local #tmp tables don't have statistics generated for them, but I was getting confused with table variables

    That solves the potential issue with concurrent users then

    🙂

    Yup I actually had to use select into #tmp for a "complex"-ish search form. Even with 10K searches / day I never had any issues.

    The fact that I had another 15 steps in the query also weighted in pretty heavily.

  • July 4, 2011 at 9:28 am

    #1347928

    Ninja's_RGR'us (7/4/2011)

    quan23 (7/4/2011)

    Aha, I was thinking that local #tmp tables don't have statistics generated for them, but I was getting confused with table variables

    That solves the potential issue with concurrent users then

    🙂

    Yup I actually had to use select into #tmp for a "complex"-ish search form. Even with 10K searches / day I never had any issues.

    The fact that I had another 15 steps in the query also weighted in pretty heavily.

    Thanks very very much !!! Your solution worked, the report runnin just fine !

  • July 4, 2011 at 9:34 am

    #1347933

    Happy to help!

  • July 4, 2011 at 9:55 am

    #1347949

    Ninja's_RGR'us (7/4/2011)

    Happy to help!

    Sorry to bother you but could you help me on this one:

    http://www.sqlservercentral.com/Forums/Topic1135057-149-1.aspx#bm1135850

    I have tried different scenarios but some I unable to comprehed while others just dont seem to work....if you could just give me some starting point, that would be great. I didnt want to break the rule by re-posting the query hence the link above.

    Thanks in advance for your help !

Viewing 4 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply