Forum Replies Created

Viewing 15 posts - 2,056 through 2,070 (of 5,678 total)

  • RE: Issue with singleton lookup sporadically taking far too long

    Brian.cs (12/29/2011)


    That brings up a good point but to clarify - they way it's structured today, the BIGINT we're trying to pull back via querying the varchar(20) Unique Clustered Index...


    - 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: Issue with singleton lookup sporadically taking far too long

    I don't have a direct cause to the issue. Btw, might I say an excellent presentation of the issue and what you've tried? 🙂

    There's a couple of places 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: Need help using function across server

    krishusavalia (12/29/2011)


    Thanks for your response.

    But How Can I pass the values of temp table to the store procedure?

    Either via a delimited list that you'd separate on the foreign server via...


    - 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: Updating Image data type with varchar datatype

    GSquared (12/29/2011)


    I don't think WriteText/UpdateText work on the (max) datatypes. They do work on Image, but you're right that it's unusual to do so.

    True, good catch. They use...


    - 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: Raw Materials - Gurgle, Incorporated

    The part that scares me is the fridge logic that hits ten minutes later...

    ... "Thank you for using Gurgle. After our analysis of your last submittal, would 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: When Would You Use the SERIALIZABLE Transaction Isolation Level

    David Moutray (12/29/2011)


    Well, I'd also have to simulate a production load on the QA and DEV systems. I'd have to get the head of IT do ... well, several...


    - 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: Updating Image data type with varchar datatype

    In general, you don't adjust image data from within SQL Server, it's just there to store the binary from another software. Most often you'll pump it out to 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: Today's Random Word!

    crookj (12/29/2011)


    WOTD - stodgy

    Waldorf (Muppets)


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

    mtillman-921105 (12/28/2011)


    Evil Kraig F, is your avatar one of them Tribbles? :w00t:

    Dustbunny, actually. 🙂

    Vacation was very good. Hadn't seen family in too long, realized I needed some 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?

    Merry Christmas all. Disappeared for a week and only 2 pages on the Thread when I came back! Y'all were slackin'! Of course, I have my post/page...


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

    Good lord. Some of you are Older than Steam!

    I'm not even going to get in this old fogie contest, best I can offer is starting out programming Basic on...


    - 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: Design Advice - Partitioned Views or Partitioned Tables?

    EAS-917374 (12/19/2011)


    There is an advantage to partitioned views which in my opinion is frequently overlooked, and that is the ability to specify multiple "partition keys", by adding multiple constraints to...


    - 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: People That Get It Done

    mojootti (12/16/2011)


    There is difference between "make is happen" and "MAKE IT HAPPEN". A manager that is trusting you to do your job and is encouraging OR is there to 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: Are the posted questions getting worse?

    Hey Jeff, I got the ultimate compliment earlier. Someone who didn't read my name on my post mistook me for you after point them in the directing them to...


    - 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 isn't my CROSS APPLY working like an inner join?

    Carl Federl (12/14/2011)


    My understanding of CROSS APPLY is that it should behave like an inner join.

    CROSS APPLY behaves like a LEFT OUTER JOIN, so you will a row for each...


    - 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,056 through 2,070 (of 5,678 total)