Forum Replies Created

Viewing 15 posts - 1,666 through 1,680 (of 5,678 total)

  • RE: Query Efficiency with left outer join and temp table

    Novice, sorry, this completely fell off my radar and I saw it cleaning out some old stuff. Are you still having issues with this? If so, I can...


    - 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: script to find orphan records on single DB

    Another option, if you don't want to fire up CLR, is to use SSIS and a script component.

    In a dataflow task, pull the table into the dataflow. ...


    - 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: Query help to exclude records

    misstryguy (4/3/2012)


    Sure Craig.

    Msg 102, Level 15, State 1, Line 19

    Incorrect syntax near ','.

    Msg 102, Level 15, State 1, Line 34

    Incorrect syntax near ','.

    Msg 102, Level 15, State 1, Line 49

    Incorrect...


    - 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 WEIRD Performance problem. Please help.

    bullo (4/3/2012)


    If I run this test against MS Access or MySql it takes aprox. 4000ms.

    If I run this test against Sql Server takes aprox. 8800ms. !!!!!!

    why is that?? again...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: BIDS Remotely Create SSIS Package

    NuNn DaddY (4/3/2012)


    Is there anyway I could "point" my local copy of BIDS to the SQL Server that has Integration Services installed on it so I no longer receive this...


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

    Lynn Pettis (4/3/2012)


    The Dixie Flatline (4/3/2012)


    Lynn Pettis (4/3/2012)


    Some people really shouldn't be allowed near SQL Server systems.

    I too resemble that remark.

    Not you either, but I just saw another who should...


    - 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: Catching the culprit!!

    GilaMonster (4/3/2012)


    Evil Kraig F (4/3/2012)


    mathew.walters (4/3/2012)


    Evil Kraig, your statement is incorrect, the host_name() function retrieves the host name of the machine making the request, I have used it 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: Catching the culprit!!

    mathew.walters (4/3/2012)


    Evil Kraig, your statement is incorrect, the host_name() function retrieves the host name of the machine making the request, I have used it in the past for auditing 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: Catching the culprit!!

    S_Kumar_S (4/3/2012)


    Moreover since all developers use common login, it will be of no use to add such column to table.

    What I need is a way to capture the hostname who...


    - 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: Timer Event in SSIS Package or method to keep package running indefinatly

    AIRWALKER-375999 (4/3/2012)


    opc.three (4/2/2012)


    You may not need to rig something like that up. What event are you waiting to see happen before your Script Tasks do work? Are you by chance...


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

    Steve, looks like you'll be coming to SQLSaturday in Phoenix. It will be a pleasure to meet you. Looking forward to it more 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

  • RE: Query help to exclude records

    If you can take a look at the first link in my signature (the left side ones) you'll see a way to present data that makes it easy for us...


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

    Big Bay Boater (4/2/2012)


    General solution for that is probably Buffalo Milk at Two Harbors.

    That would be on Catalina Island.

    O.o Huh?


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

    L' Eomot Inversé (4/2/2012)


    Anyway, it's all an evil plot by Craig to kill off the top point scorers - anyone with more than about 5000 points - so that he...


    - 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 WEIRD Performance problem. Please help.

    bullo (4/2/2012)


    Hi, thank you for reading my first post.

    I’m migrating a Classic ASP app from ACCESS to SQL Server. I RE-wrote queries, I’m not using Access with Linked Tables 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

Viewing 15 posts - 1,666 through 1,680 (of 5,678 total)