Forum Replies Created

Viewing 15 posts - 7,951 through 7,965 (of 18,926 total)

  • RE: Insert 1,000 records in one second

    Sites like myspace handle heck of a lot more than that... but still this is a nightmare to setup and maintain :w00t:.

  • RE: Insert 1,000 records in one second

    Another simple question... do you really need to log all that activity. Assuming yes you'll need a lot of hardware AND onsite consultant to get you there.

  • RE: ssrs -deploy

    How did you export the report to html?

    Basically assuming you used the export function then there's nothing you can do to bring it back to .rdl. .rdl is the...

  • RE: "SELECT @local_variable"

    Hugo Kornelis (6/25/2010)


    UMG Developer (6/25/2010)


    Hugo KornelisI did read your post, but the Connect item you linked to was not what I meant when I wrote that I knew this to...

  • RE: "SELECT @local_variable"

    Hugo Kornelis (6/25/2010)


    kevin.l.williams (6/25/2010)


    Hugo Kornelis (6/25/2010) Is 0.1% chance of incorrect results acceptable for your user?

    Not for me.

    Hugo, is this the article you were looking for?

    "The correct behavior...

  • RE: "SELECT @local_variable"

    Hugo Kornelis (6/25/2010)


    Though the explanation sounds enlightening, it is wrong. And it is also wrong to claim that the result of this query will always be "C".

    Though many people seem...

  • RE: Report Usage in Reporting Services

    Not quite true, if you add the parameter, then it's saved in the execution log already. So nothing more to do there.

    As for the parameter it's pretty simple. ...

  • RE: 95 GB Transaction Log but 99% Free

    How do you figure this will change anything to the log activity?

    Log space used grows because data is put there, sorting in tempdb won't change anything on that matter. ...

  • RE: Report Usage in Reporting Services

    I've never done that, but my first instinct would be to add an extra parameter in the report (hiden maybe) and to find a way to set that report to...

  • RE: refdate column in sysobjects table

    sqlindia (6/23/2010)


    how do we use profiler to capture the modification of objects and store the results in a table?.

    Pls help..

    What version of sql are you using?

  • RE: 95 GB Transaction Log but 99% Free

    Another quick idea, you can run this DBCC SQLPERF(LOGSPACE).

    Log that every few minutes, ideally before the t-log backups, during the day for maybe 5-7 days then see what transpires. ...

  • RE: 95 GB Transaction Log but 99% Free

    Stefan_G (6/22/2010)


    But the size of the backup is not affected by the unused part of the transaction log.

    If only 1% is used, only 1% will be backed up.

    One thing to...

  • RE: SSRS and SSAS

    😀

    Thanks for all the great input... I knew I didn't knew nearly enough about that one ;-).

  • RE: T-SQL SQL 2008

    jschmidt 17654 (6/22/2010)


    Can someone post the question? After loading all the email images in Outlook, the question image will not display for me. Thanks.

    Scroll up, hit the link...

  • RE: SSRS and SSAS

    Grant Fritchey (6/22/2010)


    In general, especially for the size of systems you're talking about, I'd seperate these installs to seperate machines.

    2 or 3?

    They're not even sure they need the technologies, this...

Viewing 15 posts - 7,951 through 7,965 (of 18,926 total)