Forum Replies Created

Viewing 15 posts - 676 through 690 (of 1,082 total)

  • RE: Need a way to speed up processing using cursor

    WEll you need to check the indexes on your tables

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 4, 2008 at 6:53 am

    #867092

  • RE: Need a way to speed up processing using cursor

    Ok, have you checked your indexes and stats?

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 4, 2008 at 6:50 am

    #867086

  • RE: Need a way to speed up processing using cursor

    ranjita.damle (9/4/2008)

    And how to do it when updating mailingname and mailingaddress fields in turn depends on entitytype of each row. so i need to traverse through it. Isnt it? Or...

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 4, 2008 at 6:40 am

    #867079

  • RE: Need a way to speed up processing using cursor

    OK cool,

    I assume the query is slow at the processing level and not at the update level?

    If so could post an execution plan please, else of the cursor version or...

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 4, 2008 at 6:39 am

    #867076

  • RE: Need a way to speed up processing using cursor

    could this not be done just using a select statement rather than a cursor?

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 4, 2008 at 6:32 am

    #867066

  • RE: Need a way to speed up processing using cursor

    Could you post you code please

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 4, 2008 at 6:17 am

    #867057

  • RE: Company Calender

    Hi there,

    Please could you give us the table structure and data in the table as well as your query.

    Please refer to this link for tips how to get the best...

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 3, 2008 at 6:09 am

    #866430

  • RE: Subquery returned more than 1 value Error...

    What do you want your results to be if there more than one row?

    Do you want to process each row or just one?

    If you just want to process one then...

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 3, 2008 at 3:22 am

    #866393

  • RE: Conditional column SELECT but fixed WHERE clause

    HI there,

    I try not to SET statements

    but this allows you to do this.

    SET QUOTED_IDENTIFIER OFF

    SELECT " tester'tester "

    Also you could look at this:

    sp_executesql

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 2, 2008 at 10:03 am

    #866071

  • RE: query suddenly goes slow - Worktable logical reads high

    HI,

    Could you give us the code cause the problem please.

    I'm also concerned that you say.

    The query plans are almost the same and not the same!

    Thanks

    Chris

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 1, 2008 at 10:32 am

    #865722

  • RE: populate a weeks worth of data from daily data

    HI Again,

    In that case could you give us the full tables and some sample data.

    Thanks

    Chris

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 1, 2008 at 10:27 am

    #865720

  • RE: populate a weeks worth of data from daily data

    Hi there,

    Normally it's a good Idea to show us what you have tried so far and then we can guide you in the right direction.

    Please refer to this ariticle for...

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 1, 2008 at 9:59 am

    #865709

  • RE: query suddenly goes slow - Worktable logical reads high

    Sorry about my first post, I see you have already looked at the stats.

    Is there anything different in the EXECUTION PLANS.

    For Example a SCAN in test where there is a...

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 1, 2008 at 9:46 am

    #865707

  • RE: Getting the first date of next year

    HEre is another solution

    DECLARE @Sample TABLE

    (

    ...

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 1, 2008 at 9:40 am

    #865704

  • RE: query suddenly goes slow - Worktable logical reads high

    have you looked at the stats on that table in live?

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

    September 1, 2008 at 9:36 am

    #865702

Viewing 15 posts - 676 through 690 (of 1,082 total)