Forum Replies Created

Viewing 15 posts - 4,531 through 4,545 (of 5,678 total)

  • RE: How do I know when to use temp tables/table variables?

    Tom.Thomson (12/16/2010)


    WayneS (12/15/2010)


    We're planning to reschedule it for the LV UG in January - they meet at 6:30PM PST - it will be done via LiveMeeting - is that something...


    - 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: View is not ordered. Why?

    Michael Valentine Jones (12/16/2010)


    There are a lot of people that think that if you do a "select * from MyTable" that it will return data in order by the clustered...


    - 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: Rolling Up Data

    Hey Jack, sorry I fell off the earth on this, kind of got distracted with my own local insanity.

    How'd this end up working out for you?


    - 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: Process of SSIS

    vikram2010 (12/16/2010)


    Hi craig i just want to know, in the interveiw what we have to explain about the SSIS job

    The correct answer, then, is: "I don't know, I haven'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: Are the posted questions getting worse?

    Brandie Tarvin (12/16/2010)


    Steve Jones - SSC Editor (12/16/2010)


    I think Intellisense can make this just as bad. If you're used to using "p", downarrow to get to ProductDetail and someone adds...


    - 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: Process of SSIS

    Well, this depends on how you run it. If they manually trigger the job, they get a little box on the screen showing it's running, then either error or...


    - 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: We Are Not a Meritocracy

    TravisDBA (12/15/2010)


    I worked in a shop where we bantered crudely and rudely back and forth all day. Females were included, even expected to join. The three in 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: We Are Not a Meritocracy

    TravisDBA (12/15/2010)


    True story, but I still maintain that many interviews are deceiving. Have you ever seen the movie "The Shining"?:-D

    Worse in our case is the 'Job built for Bob' scenario...


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

    Heh, and here I just dropped a line on the original article about what Jeff explains clearly in that link above. The division from decimal(x,x), at least on 2k5,...


    - 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: Passing NULL values while using Multivalue parameters

    srinivas-406082 (12/15/2010)


    I'm using multi value parameters in one of my reports and I'm calling the report from an aspx page.

    My report runs just fine when I select one or...


    - 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 in my procedure

    CELKO (12/15/2010)


    =================

    DECLARE

    @mon1 MONEY,

    @mon2 MONEY,

    @mon3 MONEY,

    @mon4 MONEY,

    @num1 DECIMAL(19,4),

    @num2 DECIMAL(19,4),

    @num3 DECIMAL(19,4),

    @num4 DECIMAL(19,4);

    SELECT

    @mon1...


    - 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 take a table offline?

    Agreed with Gus above, more information about what you're trying to do would help.

    If you're just trying to see if anyone uses it (the old, shut it off and listen...


    - 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 Make a Dynamic Stored Procedure Query

    dso808 (12/15/2010)


    Got it Craig. here it is:

    SET @Where = @Where + 'AND ProbTicketSubDept LIKE ''%'' + @_Dept + ''%'' '

    All single quotes of course. Seems to be working...


    - 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 in my procedure

    Actually, the WHERE 1=1 is a neat little trick to avoid doing extra if statements to determine if something starts the clause and needs an AND. Since 1=1 is...


    - 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 some help with a large data volume optimization

    WayneS (12/15/2010)


    Paul White NZ (12/15/2010)


    LutzM (12/15/2010)


    What would it help in Craigs scenario to lock the door, dim the light and ignore the ringing bell? :unsure: 😀

    The last thing Craig needs...


    - 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 - 4,531 through 4,545 (of 5,678 total)