Forum Replies Created

Viewing 15 posts - 931 through 945 (of 5,678 total)

  • RE: Demanding and difficult logic qns. Sorry but i need help.

    10e5x (12/10/2012)


    Ok Jeff I got it. So I can't use your method? Even if I create those task? So sad, so wasted anyway thanks for the help.

    Btw if I...


    - 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: Modeling Survey Data

    MikeBrey (12/7/2012)


    Same questions different vendors. Would you still recommend the snowflake?

    Yes and No. I'd probably move Vendor over to the Fact table but stay with the same general pattern....


    - 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: Modeling Survey Data

    MikeBrey (12/7/2012)


    These surveys run for only two weeks twice a year and sometimes for the same vendors. The employee response date they are not too concerned about. Wouldn't you 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: Made stupid mistake, need help removing duplicates

    Jeff Moden (12/7/2012)


    {edit} I see Craig already covered the backup recommendation. I didn't look any further down when I saw the message. All I saw was "Oh...


    - 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: Modeling Survey Data

    That looks about right to me, however I'd have the survey itself linked off as a snowflake for survey/question dimensions (so I could pull up the actual question for reports...


    - 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: Made stupid mistake, need help removing duplicates

    ryetimothy (12/7/2012)


    So I ran the test code and it worked. I'm guessing my next step is to try it on a section of the real table, but I had...


    - 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 packege run good on BIDS, but when set up to run in SQL Agent job, always fail duw to access

    You have different security rights to the DB2 components then the SQL Agent does. You need to find out what login the Agent is running under and change 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

  • RE: TSQL question (join tables)

    DZN61 (12/7/2012)


    I have 5 tables

    Reports : which contains the name of the reports

    Cars : which contains the name of the cars

    Parts : which contains the name of parts

    CarsAndParts : which...


    - 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: Modeling Survey Data

    Well, without the DDL for the tables it's hard to answer your question directly. I'm having a real hard time following what your question actually is, unfortunately. That's...


    - 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: Newbie Question - Saving SSIS Packages

    Silly question, but what is SSDT? Is that something new in SQL 2012?

    I personally have always saved to filesystem first so we can sourcesafe the packages, or at 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: Made stupid mistake, need help removing duplicates

    Okay, so we're back to the original idea of what we were looking to do. However, before you trust this code, make sure that you check the results 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

  • RE: Are the posted questions getting worse?

    Evil Kraig F (12/6/2012)


    Brandie Tarvin (12/6/2012)


    Hey, all. I don't know if I posted this before or not. If you're interested in writing, I have a special call that opens in...


    - 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: Made stupid mistake, need help removing duplicates

    ryetimothy (12/7/2012)


    Here's the CREATE TABLE script for the full table, the consumable data is below. I had to exclude some of the variables due to length restrictions for QUOTENAME...


    - 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: Made stupid mistake, need help removing duplicates

    ryetimothy (12/6/2012)


    Thanks for the reply! Each record has a datetime stamp, but for some reason they're not consistent, meaning that some duplicated records have the same datetime stamp, but some...


    - 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?

    Brandie Tarvin (12/6/2012)


    Hey, all. I don't know if I posted this before or not. If you're interested in writing, I have a special call that opens in February for science...


    - 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 - 931 through 945 (of 5,678 total)