Forum Replies Created

Viewing 15 posts - 2,986 through 3,000 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (6/15/2011)


    here's a couple links that might be worth looking at.

    You can get pretty granular with constrained delegation.

    Thank you. Unfortunately I don't think they're actually going to expose...


    - 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: SQL Server 2008 bit field best design practices

    Some Bit vs. Bitmap testing. My comments and notes are in the code, as is the build end to end.

    Remember to run the testing queries twice for proper statistics,...


    - 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: Why? Just because...

    Michael Valentine Jones (6/14/2011)


    Actually need a feature the Oracle has that SQL Server doesn't. ( just kidding, decisions like that are never made for practical reasons :laugh: )

    LOL, thanks...


    - 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: SQL Query

    CELKO (6/14/2011)


    >> One team can only have 2 students as shown in the data above. I want to write a query which will return the team_nbr and the id/name 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: SQL Server 2008 bit field best design practices

    opc.three (6/14/2011)


    Craig Farrell (6/14/2011)


    I'll see if I can't dig up some of my older scripts I used.

    I'd be interested in seeing those if you happen to dig them up. 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

  • RE: How to circumvent SSIS validation when running package as a scheduled task?

    Charles Hottle (6/14/2011)


    I've always used a dummy file with the correct structure for situations like this.

    I do the same as Charles with this. Royal PITA but never really found...


    - 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: Why? Just because...

    Golf Game Sales Deal, probably. Or dirty pictures after that Swedish Skiing Vacation. Or a fast talking salesman who showed biased charts to business people who don't know...


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

    Need a fast flavor.

    Does anyone out there know of an in-depth article or discussion on the deep impact and exposure caused by allowing Kerberos Double-Hop delegation?

    I've never seen a problem...


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

    WayneS (6/14/2011)


    Craig, Trey and any others out in AZ... you'll okay with all those fires going on? (I know it's not that close to you'll, but smoke travels and causes...


    - 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: Help me

    The transaction exists in the controlling container, usually a sequence container. That transaction surrounds every object internal to it unless you create another transaction internally to it.

    When a transaction...


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

    Craig Farrell (6/14/2011)


    Brandie Tarvin (6/14/2011)


    Trey Staker (6/14/2011)


    @craig-2 -- Did you know that Brian Knight will be teaching a 3 day SSAS training class here in Phoenix June 21-23? ...


    - 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 (6/14/2011)


    Trey Staker (6/14/2011)


    @craig-2 -- Did you know that Brian Knight will be teaching a 3 day SSAS training class here in Phoenix June 21-23? I just...


    - 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: Etiquette

    Regarding the Success vs. Fail messages, SQL Server has long had known issues always emailing, and it can't tell you when it's failing email because... it can't email.

    One shop 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: SQL Server 2008 bit field best design practices

    GilaMonster (6/14/2011)


    Craig Farrell (6/14/2011)


    I personally like bit fields, and bitmap fields.

    Bits yes, bitmaps no.

    Technically they violate 1st normal form. They're non-intuitive to people who haven't been exposed to them 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

  • RE: Database Design - Separating tables (1 to 1 relationship)

    GSquared (6/14/2011)


    Craig Farrell (6/13/2011)


    I'm afraid I would disagree with Carlos above, however, my approach is very different for ultra-wides.

    For the primary table, make sure it has your business keys 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

Viewing 15 posts - 2,986 through 3,000 (of 5,678 total)