Forum Replies Created

Viewing 15 posts - 1 through 15 (of 111 total)

  • RE: Reports will not render from local server

    Found a solution to the fireFox authentication issue

    Type about:config into the address bar and click on the button to bypass the warning.

    find the entry that reads network.automatic-ntlm-auth.trusted-uris and add the...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Reports will not render from local server

    Yeah, tell me.

    I have one question you may be able to answer. When I connect using fireFox it asks me for my network credentials before continuing. Any idea...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Reports will not render from local server

    Yes, just double checked. Closed all instances of IE, ran a new instance as an administrator, same issues.


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: model database won't restore

    Yes, we'd already ploughed through that articel and were using both trace flags. But the message we keep getting in "The system database cannot be moved by RESTORE"


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Data Flow Script Transformation and Pre/PostExecute methods - when do they run

    I've run some more tests and what I'm getting is that the PreExecute() executes as soon as the entire data flow starts, the PostExecute() executes as soon as the data...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: WMI and moving files

    Thanks Phil, the component does exactly what I need and has solved the issue admirably.


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: SQL Refusing to use an index

    Yup, all tables had their statistics updated with FULLSCAN after migration, and the migration actually occurred 4 years ago and statistics have been updated frequently since then to ensure that...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Sanity Check - using CASE in WHERE clauses

    Brendan: The only thing which makes multiple procedures for parameters a pain is where I have 5 or 6 optional parameters with multiple combinations - it would mean hundreds of...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Sanity Check - using CASE in WHERE clauses

    Breandan: This has work very well for me in the past where we have been able to do it.

    In our situation we had a complex query that was required to...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Sanity Check - using CASE in WHERE clauses

    Good point, that had slipped my mind. Thanks.


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Sanity Check - using CASE in WHERE clauses

    Gilamonster: I was expecting to see exactly what you showed, and it was the fact that I wasn't that was causing me confusion. I tried the procedure without clearing...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Sanity Check - using CASE in WHERE clauses

    I don't want to use the option RECOMPILE. These procedures are almost always driving the websites and get hit magnitudes more than our in-house apps, so it is going...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Sanity Check - using CASE in WHERE clauses

    Grief, were you sitting on the forum!!! That was an incredibly fast response - thanks! :w00t:

    I think the word I'm looking for is "bugger". I was really hoping that...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Procedure cache with low memory size and low hit rate.

    I'll dig back through the history and check the semaphores.

    As for anything running, we couldn't see anything at all, no index rebuilding, dbcc's, page spltting, etc.

    The only thing that i...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Procedure cache with low memory size and low hit rate.

    Was this ever resolved?

    I am encountering the same issue with my SQL Server.

    It is on a server dedicated to SQL Server with nothing else running on it. Occasionally I...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

Viewing 15 posts - 1 through 15 (of 111 total)