Forum Replies Created

Viewing 15 posts - 1,456 through 1,470 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    ACinKC (6/18/2012)

    It appeared to me, just like the other post that Brandie quoted, that you had felt you had to proactively throw up a defense against some kind of attack...

    - 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

    June 18, 2012 at 2:13 pm

    #1502441

  • RE: Is MERGE always the way to go for upserts?

    Oksana March (6/16/2012)

    Hi Craig,

    Can you help me understand this better? I would not be able to explain it to my rubber ducky for sure, if I had one 🙂 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

    June 18, 2012 at 2:05 pm

    #1502439

  • RE: Sum the most recent record for each day

    CELKO (6/16/2012)

    There is no need to write 1970's Sybase dialect any; use ANSI Standard syntax:

    Unless, of course, you're creating code that someone who's working on older systems will be able...

    - 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

    June 17, 2012 at 7:25 pm

    #1502060

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/15/2012)

    Craig,

    I don't have a Rubber Ducky. Can I borrow yours, please?

    Here's the best I've got for 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

    June 17, 2012 at 6:51 pm

    #1502057

  • RE: Key Assignment in a Calendar Table that Has Duplicate Dates

    dj1202 (6/15/2012)

    Evil Kraig F (6/15/2012)

    dj1202 (6/15/2012)

    There are duplicate dates (each correspond with a unique invoice number). Therefore, it will not let me assign. Any suggestions on how one should approach...

    - 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

    June 15, 2012 at 6:29 pm

    #1501924

  • RE: Sum the most recent record for each day

    Like so? (btw, thanks for the easy to use data)

    SELECT

    SUM( Value) AS SumValue

    FROM

    (SELECT

    --DATEADD( dd, DATEDIFF( dd, 0, DateTimeStamp), 0) AS DayOfRecord,

    MAX( DateTimeStamp) AS MaxDT

    FROM

    #Test

    GROUP BY

    DATEADD( dd, DATEDIFF( dd, 0,...

    - 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

    June 15, 2012 at 5:36 pm

    #1501921

  • RE: Key Assignment in a Calendar Table that Has Duplicate Dates

    dj1202 (6/15/2012)

    There are duplicate dates (each correspond with a unique invoice number). Therefore, it will not let me assign. Any suggestions on how one should approach this?

    I'd have to go...

    - 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

    June 15, 2012 at 3:49 pm

    #1501908

  • RE: Can you use full text contains to match two similar fields in two seperate tables?

    This really doesn't work for Full-Text. Full-Text indexing's purpose really is single column use. However, you may want to investigate the Fuzzy Lookup component in SSIS. It,...

    - 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

    June 15, 2012 at 3:45 pm

    #1501907

  • RE: Is MERGE always the way to go for upserts?

    Merge's power is in the single transaction / modification capability for both sides of the Upsert, which implies multiple rows, and not having to double-pass the data.

    By doing a select...

    - 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

    June 15, 2012 at 3:43 pm

    #1501906

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/15/2012)

    Brandie Tarvin (6/15/2012)

    Craig, I read the "Devil" comment to refer to the evil commenters who make people post things like "please don't flame" and "put me over 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

    June 15, 2012 at 3:30 pm

    #1501904

  • RE: Are the posted questions getting worse?

    Revenant (6/15/2012)

    ACinKC (6/15/2012)

    I think it's more widespread than some might be aware of, which means that the problem is that some aren't even picking up that the way they respond...

    - 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

    June 15, 2012 at 1:15 pm

    #1501859

  • RE: Assigning attorneys to paralegals

    dtoews 7666 (6/14/2012)

    This seems to work, Kraig. I had gotten to the point of the self join, but I had no idea about the XML PATH command to bring...

    - 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

    June 14, 2012 at 3:05 pm

    #1501296

  • RE: Is Oracle DBA is nore harder than SQL DBA

    I believe I can sum up the difficulty with Oracle compared to SQL Server with a quote I once heard an old Mainframer tell me when I started.

    "If it's not...

    - 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

    June 14, 2012 at 3:01 pm

    #1501295

  • RE: general indexing question

    Personally, I'd look at how your restrictions are actually working. The reason for this is because date in this case as the leading edge is probably not your best...

    - 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

    June 13, 2012 at 4:10 pm

    #1500714

  • RE: Assigning attorneys to paralegals

    First, let me say nice work on the data setup and results, however, you didn't test it and you missed a spot. It needs quotes for the text entries,...

    - 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

    June 13, 2012 at 3:13 pm

    #1500697

Viewing 15 posts - 1,456 through 1,470 (of 5,678 total)