Forum Replies Created

Viewing 15 posts - 16 through 30 (of 56 total)

  • RE: large self-join taking ages, anything I can do?

    jcb (3/12/2012)

    To compare between machines use a dump from the prod server (if possible)

    Comparation between 5 millions of nulls or small strings is faster than comparing 3 milllions large strings...

    Anyway...

    March 13, 2012 at 9:21 am

    #1458570

  • RE: large self-join taking ages, anything I can do?

    Eugene Elutin (3/12/2012)

    Looking into your UDF, it would definitely benefit from implementing it as CLR function.

    Also, you can try to split your query in two parts.

    First filtering out everything...

    March 13, 2012 at 9:17 am

    #1458565

  • RE: large self-join taking ages, anything I can do?

    Updt:

    It dont surprises me to make a nested while string manipulation (5 million X 5 million) times takes a long time.

    Me either. Though it does seem to be a...

    March 12, 2012 at 11:30 am

    #1458051

  • RE: large self-join taking ages, anything I can do?

    Sean Lange (3/12/2012)

    CraigIW (3/12/2012)

    Hi Sean,

    Sorry, I'm a bit tired. You are right about the ISNULL. It is there as the column is nullable, but the expressions are equivalent.

    The...

    March 12, 2012 at 11:16 am

    #1458040

  • RE: large self-join taking ages, anything I can do?

    Hi Sean,

    Sorry, I'm a bit tired. You are right about the ISNULL. It is there as the column is nullable, but the expressions are equivalent.

    The UDF is what...

    March 12, 2012 at 10:25 am

    #1457995

  • RE: large self-join taking ages, anything I can do?

    Hi Usman,

    Thanks for your reply.

    I'm trying to wrap my head around the differences between my original query and what you suggest. The goal of the query is...

    March 12, 2012 at 8:49 am

    #1457903

  • RE: Database copy for reporting

    PaulB-TheOneAndOnly (2/6/2012)

    One last question... any particular reason not to upgrade reporting SQL Server instance to SS2K8 R2? that would make things much easier and standardize your environment.

    Check if you...

    February 7, 2012 at 2:40 am

    #1443599

  • RE: Database copy for reporting

    SQLKnowItAll (2/6/2012)

    I have to ask this... Why does the data need to be moved? You can report off of your existing database and not affect performance in many cases. ...

    February 7, 2012 at 2:35 am

    #1443597

  • RE: Database copy for reporting

    Dev (2/6/2012)

    What about copy database task? 5 GB database on 2 VMs on LAN, it shouldn’t be a problem.

    Try it with wizard & save it as SSIS package,...

    February 6, 2012 at 8:04 am

    #1443165

  • RE: Database copy for reporting

    ALZDBA (2/6/2012)

    CraigIW (2/6/2012)

    ALZDBA (2/6/2012)

    as always, it depends 😉

    - Can your need be solved using backup ( of prod ) and restore ( to report env ) ?

    ( one...

    February 6, 2012 at 7:40 am

    #1443134

  • RE: Database copy for reporting

    Dev (2/6/2012)

    Please don’t complicate the things. For your requirements FULL Backup & Restore is most suited option.

    But that won't work as I need to go R2 > 2008.

    February 6, 2012 at 7:32 am

    #1443127

  • RE: Database copy for reporting

    Dev (2/6/2012)

    Please don’t complicate the things. For your requirements FULL Backup & Restore is most suited option.

    PS how far is Source and Target database Servers? Do you have...

    February 6, 2012 at 7:30 am

    #1443125

  • RE: Database copy for reporting

    PaulB-TheOneAndOnly (2/6/2012)

    5 Gig database?

    Nighly?

    The answer is: Full Backup and Restore.

    Yes 5Gb nightly (x 2 actually).

    Cannot restore a 2008 R2 database to 2008.

    February 6, 2012 at 7:22 am

    #1443113

  • RE: Database copy for reporting

    ALZDBA (2/6/2012)

    as always, it depends 😉

    - Can your need be solved using backup ( of prod ) and restore ( to report env ) ?

    ( one should be...

    February 6, 2012 at 7:10 am

    #1443103

  • RE: Database copy for reporting

    v_nikonor (2/6/2012)

    i think , Logshipping is best option for you night create database copy and for reports.

    and specifying question

    How much data of databases? and How much data is changing?

    ~5Gb...

    February 6, 2012 at 6:50 am

    #1443090

Viewing 15 posts - 16 through 30 (of 56 total)