Forum Replies Created

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

  • RE: I need only SQl Server Agent

    Gianluca Sartori (5/23/2012)


    Sorry to say that, but I don't think you should be using SQL Server Agent as a job scheduler if you don't need SQL Server in the first...


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

    SQLRNNR (5/23/2012)


    SQL Kiwi (5/23/2012)


    Bye Jason. Schoolboy error.

    Nope -planned psychological experiment.

    This isn't a psychological experiment unless you're trying to determine the psychosis of a Bronco's fan in light of 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: Not exactly code review or source code control

    If you can't clarify with the end user, the intermediary has to. If the intermediary won't, then you need to go up your own chain of command and back...


    - 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: I need only SQl Server Agent

    Tara-1044200 (5/23/2012)


    I wanted to use SQL Server Agent for shcduling the windows jobs as i think sql jobs more robust than windows schduler, do i have install the complete server...


    - 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 (5/23/2012)


    SQLRNNR (5/23/2012)


    Steve Jones - SSC Editor (5/23/2012)


    Stefan Krzywicki (5/23/2012)


    Tom Brady? He'll be retiring soon.

    We can only hope.

    Nah - I want to see him beat down the Broncos 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: Are the posted questions getting worse?

    Pardon me, I'd just like to vent briefly about SSRS.

    YOU LOUSY PIECE OF DUNG INANE INTERFACE. MS ACCESS has more ability and stronger methodology than YOU! YOU ARE...


    - 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: Will partitioning help?

    GilaMonster (5/22/2012)


    andersg98 (5/22/2012)


    Yes. The concept is called 'partition elimination'. Especially when scanning the table for a date range, the optimizer will realize it only has to scan 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: Are the posted questions getting worse?

    SQL Kiwi (5/22/2012)


    Stefan Krzywicki (5/22/2012)


    Lynn Pettis (5/22/2012)


    If people would just format their code they could figure out some of their own problems. Geez.

    Many should format it all at once,...


    - 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: Many to one TOP N UPDATE troubles

    I debated on leaving this alone since the OP is good to go but I don't want to see others confused by this. Although, if you're going to boilerplate...


    - 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: rows to columns

    chandrika5 (5/18/2012)


    The problem I have is:

    descr

    Amt

    Cnt

    are variables and can go upto 15 also. I do not have control on these fields as these are configurable by users.

    Ignoring our local wild...


    - 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 Cost 27%

    Alright, I found where I pulled .3% out of ... the Aether... and realized why I'd done it.

    For those interested, a more in depth discussion can be found here from...


    - 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 Cost 27%

    GilaMonster (5/18/2012)


    Evil Kraig F (5/18/2012)


    I think I'll go re-read your blog a few times until it gets better stuck in my head. 🙂

    That's not on my blog. It's stuff I've...


    - 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 Cost 27%

    GilaMonster (5/18/2012)


    Evil Kraig F (5/18/2012)


    Apologies for the confusion. Yeah, my numbers were off too, sorry, it's 0.003 or .3%... and I dropped it in the middle of the two,...


    - 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: Importing Multiple csv files into one SQL Table

    Jeff Moden (5/18/2012)


    Lowell (5/18/2012)


    I'll go all devils advocate on the SSIS guys and present a solution i put together for other posts that is all TSQL.

    Thsi requires xp_cmdshell to get...


    - 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 Cost 27%

    Jeff Moden (5/17/2012)


    No problem. Thanks.

    I ran the test you included in the Blog entry and actually did get seeks at the .5% and .3% levels instead of scans, but...


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