Forum Replies Created

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

  • 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...

  • RE: Are the posted questions getting worse?

    Wow a 323 GB DB for US Veterans. The guy needs help knowing the setup for SSAS AND SSRS. I'm a little out-classed on that one.

    http://www.sqlservercentral.com/Forums/Topic941073-391-1.aspx

  • RE: SSRS and SSAS

    0.3 TB of data for the veterans DB WOW.

    With that scenario in mind there may be a way to use the same server for all 3.

    Depending on how and who...

  • RE: Upgrading Database Compatibility Level When Database is already on 2008 SQL Server

    Only 1 solution here ... test it out.

    Depending on the importance of the applications that are using the databases :

    1 - If not critical, take backup in 80 or...

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