Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 5,678 total)

  • RE: Can I rewrite the following query without using Row_number() function ??!!

    mounish (1/13/2011)

    When I embed this query in between many other queries along with JOINs, My oracle server is unable to execute.

    Just an FYI: You realize you posted this...

    - 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

    January 13, 2011 at 11:47 am

    #1273206

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/12/2011)

    I think that green is an appropriate color for the US

    Did you have half an hour of work you were looking to pay me for...

    - 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

    January 12, 2011 at 3:48 pm

    #1272698

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/12/2011)

    Grant Fritchey (1/12/2011)

    WayneS (1/12/2011)

    Grant Fritchey (1/12/2011)

    Anyone interested in reading a short blog post? I'm a little nervous about putting this one up. I'm talking about how heaps are...

    - 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

    January 12, 2011 at 11:43 am

    #1272534

  • RE: Error Runing the Package SSIS.

    Post the script? My guess is you've got invalid 2k5 syntax (IE: MERGE). The other option is you need to turn on bypass prepare.

    - 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

    January 11, 2011 at 5:59 pm

    #1272147

  • RE: CASE vs JOIN

    Vedran Kesegic (1/11/2011)

    In short: no. You probably will not have significant performance gains if you use "mutant" CASE statement.

    I'll agree with this, but add a few things.

    Regarding joins, check out...

    - 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

    January 11, 2011 at 4:28 pm

    #1272133

  • RE: Security laws and publicly-traded companies

    Indianrock (1/11/2011)

    The problem of complying with laws in multiple states reminds me of how the SEC and other regulatory bodies failed in regulating Wall Street. A domestic-only focus...

    - 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

    January 11, 2011 at 2:15 pm

    #1272094

  • RE: Proc Performance

    Reji PR (1/11/2011)

    I am not understanding, why you are using dynamic sql string?

    If My understanding is correct, you need to set the arguments in the where clause based on the...

    - 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

    January 11, 2011 at 12:05 pm

    #1272021

  • RE: Assigning values to multiple variables with single SELECT (with a twist)

    GSquared (1/11/2011)

    Jeff Moden (1/10/2011)

    WayneS (1/10/2011)

    Craig Farrell (1/10/2011)

    GSquared (1/10/2011)

    Since you're using SQL 2008, can you switch from delimited lists of parameter values to a table variable parameter? Those are more...

    - 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

    January 11, 2011 at 11:24 am

    #1272005

  • RE: Service Broker Activation not firing off

    Service Broker doesn't remove messages immediately, for a couple of internal reasons. It also won't remove messages that don't close the dialog properly.

    Check out these articles, specifically the parts...

    - 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

    January 11, 2011 at 11:04 am

    #1271993

  • RE: SQL Issues

    You are under a brute force attempt to login, there's a virus or a trojan on your system.

    Get a network security expert in NOW.

    The login is always changing, and its...

    - 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

    January 11, 2011 at 10:59 am

    #1271990

  • RE: Security laws and publicly-traded companies

    ^ Elliott's right. I blame it still being morning, sorry... and I was thinking of data security and protection in a different light.

    I live and breath SOX so often...

    - 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

    January 11, 2011 at 10:57 am

    #1271986

  • RE: Security laws and publicly-traded companies

    The majority of laws for businesses come from three places these days. OSHA, HIPPA, and SEC.

    When you say security laws, do you mean *trading* securities (stocks, bonds, options), or physical...

    - 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

    January 11, 2011 at 10:11 am

    #1271960

  • RE: Please help with SQL code

    pwalter83 (1/11/2011)

    Hi Craig,

    Thanks for your reply. The NCV_BL_DHL_TEMP table will be joined to MG_Location on

    NCV_BL_DHL_TEMP.POL_COUNTRY_CD = MG_Location.COUNTRY_CD

    Hope that helps.

    Kind Regards,

    Paul

    Precisely the issue. There's two FR rows and you're...

    - 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

    January 11, 2011 at 2:31 am

    #1271762

  • RE: Rewriting the query without using 'Insert' <Query Optimization>

    Jeff Moden (1/10/2011)

    Actually, WITH was available in Oracle long before SQL Server. They don't call it a "CTE", though. Instead, they call it "Sub-Query Refactoring" and it works...

    - 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

    January 10, 2011 at 9:55 pm

    #1271709

  • RE: Please help with SQL code

    Got distracted a while.

    Here's part of the problem:

    /*

    --One FR sample row

    insert into NCV_BL_DHL_TEMP

    values('10443663', 'LEH901114', 'SAEME', 'FR', 'HK', 'SVB', '648E', 'E', '02-06-2009', '2');

    -- ALL MG_Location Sample rows

    insert into MG_LOCATION

    values('FRTAR', 'TARNOS', 'B',...

    - 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

    January 10, 2011 at 5:31 pm

    #1271673

Viewing 15 posts - 4,396 through 4,410 (of 5,678 total)