Forum Replies Created

Viewing 15 posts - 4,546 through 4,560 (of 5,678 total)

  • RE: Need some help with a large data volume optimization

    Paul White NZ (12/14/2010)

    Craig,

    For the deletes, use this:

    DELETE psa

    FROM #DelPortList AS dpl WITH (TABLOCKX)

    JOIN PortSecAgg AS psa WITH (TABLOCKX)

    ON psa.PortfolioID = dpl.PortfolioID

    AND...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 15, 2010 at 10:54 am

    #1263029

  • RE: How to Make a Dynamic Stored Procedure Query

    dso808 (12/15/2010)

    Hi Gail - to intialize @Where, I did this right after declaring it:

    SET @Where = ''

    When I tried to do this:

    @Where NVARCHAR(4000) = ''

    I got this error message:

    Cannot assign...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 15, 2010 at 10:43 am

    #1263023

  • RE: Are the posted questions getting worse?

    WayneS (12/14/2010)

    Gail, are you trying for sainthood?

    Yeah, she is.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 11:15 pm

    #1262631

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (12/14/2010)

    Is it now more, or less, frightening?

    I'm now wishing I was underwater in the scuba gear... kilts skeer me! Won any blue ribbons you...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 3:51 pm

    #1262579

  • RE: Need some help with a large data volume optimization

    LutzM (12/14/2010)

    Any chance to post the index def for #DelPortList and PortSecAgg? It seems like the clustered indexes don't match.

    They don't, not directly.

    #DelPortList's index is in the proc, listed here...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 3:45 pm

    #1262575

  • RE: Need some help with a large data volume optimization

    JAWDROP.

    Step - Find duplicated AsOfDate/PortIDs between batches: 75 seconds.

    Step - Remove duplicated AsOfDate/PortIDs between batches: 0 seconds.

    Step - Declare and open cursor: 0 seconds.

    Step - Insert into #DelPortList for Batch...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 3:37 pm

    #1262573

  • RE: View is not ordered. Why?

    evald (12/14/2010)

    It seems that Microsoft agree with me

    http://support.microsoft.com/kb/926292

    I'm going to verify if this hotfix is installed on my sql server and also i'll verify on a sql server 2008

    Of...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 3:30 pm

    #1262567

  • RE: Need some help with a large data volume optimization

    Ignore this, bad post.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 3:19 pm

    #1262565

  • RE: Need some help with a large data volume optimization

    Alrighty. So, status update on the processing so far.

    I am still doing an all file load to the _staging table. The reason for this necessity is some business...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 2:36 pm

    #1262533

  • RE: Are the posted questions getting worse?

    GilaMonster (12/14/2010)

    Brandie Tarvin (12/14/2010)

    (Where's my halo? Self-righteous doesn't work without my halo, darnit!)

    How long did it take you to forge your own halo, in between the lightning strikes, Gail? ...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 1:41 pm

    #1262463

  • RE: Login Failed error when trying to browse SSIS packages

    bleach (12/14/2010)

    Yes, indeed I see that service running on the server. I've attached a screen shot.

    Then it's got to be login related, or a serious glitch on the system....

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 1:36 pm

    #1262458

  • RE: Are the posted questions getting worse?

    GSquared (12/14/2010)

    Alvin Ramard (12/14/2010)

    Stay out of the gutter Gus. It's crowded enough in here without you. 😛

    Trust me, I am WAY below the gutter.

    Marianas Trench is uphill from...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 1:30 pm

    #1262452

  • RE: Login Failed error when trying to browse SSIS packages

    This is sounding like SSIS wasn't installed, at all.

    Can you check the services on that machine, make sure you see a running SQL SERVER INTEGRATION SERVICES on that system? ...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 11:30 am

    #1262384

  • RE: Round to next 1000 or 100 without Ceiling function

    For some reason straight integer divide didn't want to work here, I had to actually convert it on my 2k5. Wierdness.

    declare @numeric decimal(32, 8)

    set @numeric = 1.02

    print ( CONVERT(...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 10:24 am

    #1262350

  • RE: Need some help with a large data volume optimization

    Gyeah!!!! Hold on Paul! 😀

    My word man, you make me look like I never type anything! 😛 Though, I appreciate the extensive discussion. Don't misunderstand.

    Going to tackle...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 14, 2010 at 12:09 am

    #1262051

Viewing 15 posts - 4,546 through 4,560 (of 5,678 total)