Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 5,678 total)

  • RE: SubQuery problem

    Here we go again.

    CELKO (3/9/2012)


    This is minimal polite behavior ON a SQL forum.

    Please, remove this comment from your cut and paste. The hypocrisy is stifling and I don't...


    - 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

  • RE: SubQuery problem

    jjohnson 40837 (3/8/2012)


    We see by my data the current query doesn't pull the total records for #2 but only record 1 & 3, I've adjusted my SQL to use a...


    - 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

  • RE: Replacing NULL measure with a value or zero

    You don't necessarily want to default the cube to replace nulls with 0s because then it'll set your averages and counts to be inaccurate. Unless, of course, you WANT...


    - 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

  • RE: If Statement...2nd try...:)

    jbalbo (3/8/2012)


    SELECT TAG_NAME = 'CUST_CLIENTNAME', TAG_DATA = (SELECT C.FNAME + CASE WHEN C.MNAME IS NULL THEN '' ELSE ' ' + C.MNAME END + ' ' + C.LNAME

    FROM CLIENT C...


    - 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

  • RE: SSIS question

    Lynn Pettis (3/8/2012)


    Have to ask, but why the restriction on the number of records in each file? Personally, I can't think of a good business case for this.

    In my...


    - 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

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (3/8/2012)


    mtillman-921105 (3/6/2012)


    Look, the first invisible car?

    I think it might create some problems if those were let loose in traffic.;-)

    I want two... I know I'm end up wrecked...


    - 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

  • RE: SSIS question

    Recently did this.

    Create a proc performing the file grouping like above with row_number().

    Perform an execute sql task to determine the max file iteration you need from the query....


    - 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

  • RE: Long running query on only one server

    SQLJocky (3/8/2012)


    I have a query that ran in 3 seconds on a 2008 server, then we moved the database and everything to a different 2008R2 server (backup, restore) and now...


    - 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

  • RE: SSIS

    ramchandra2cool (3/6/2012)


    How is that it is taking in SSMS only 9 secs. And when i place the same query in the SSIS it is taking more time to pull 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

  • RE: Are the posted questions getting worse?

    SQLRNNR (3/6/2012)


    jcrawf02 (3/6/2012)


    Evil Kraig F (3/6/2012)


    And a week of troubleshooting later I'm back.

    If, for some reason, you just can't seem to get the login for SSC to work (page cannot...


    - 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

  • RE: Are the posted questions getting worse?

    jcrawf02 (3/6/2012)


    Evil Kraig F (3/6/2012)


    And a week of troubleshooting later I'm back.

    If, for some reason, you just can't seem to get the login for SSC to work (page cannot be...


    - 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

  • RE: Are the posted questions getting worse?

    And a week of troubleshooting later I'm back.

    If, for some reason, you just can't seem to get the login for SSC to work (page cannot be displayed), turn on SSL...


    - 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

  • RE: How do I return only entries with multiple categories in a junction table?

    drew.allen (2/27/2012)


    CELKO (2/23/2012)


    Start using the ANSI/ISO row constructors

    Evil Kraig F (2/27/2012)


    Nah, I much prefer something that makes sense to the people I work with instead of forcing them to conform...


    - 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

  • RE: Running Sql Server Program files on RAID10 - is this necessary for performance ?

    isuckatsql (2/27/2012)


    I know that you should run SQL data files on RAID10, which i have.

    I've run many large systems on RAID-5 with limited issues. Failure exposure is higher but...


    - 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

  • RE: Better option than using Stored procedures

    raghuveer126 (2/24/2012)


    My team mate suggested me its beter that SQL query be in the report rather than using SP. But i have parameters and how can i put sql...


    - 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

Viewing 15 posts - 1,726 through 1,740 (of 5,678 total)