Forum Replies Created

Viewing 15 posts - 1,516 through 1,530 (of 5,678 total)

  • RE: Hi, Cant I post here Large sql Statement?

    Sure, go for it. It'll help if you use the code="sql" wrapper you'll see on the left when you're posting, as it'll help keep format and the like for...


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

    pallavi.unde (6/4/2012)


    Is there any optimized / repair command require for database to increase a performance ???

    Monster.com, Ladders.com, etc...

    You need a professional if you need heavy duty perfomance tuning.

    That said,...


    - 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 reduce high CXPACKET

    CXPacket as you've already realized is merely parallelism waiting on certain threads. The CXPacket is rarely the cause of the issue, but a symptom. What you'll need 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: What are the implications of backing up a database more than once to the same file

    SQLUserC (6/1/2012)


    But if you write multiple backups to the same file, will SQL know to restore the most recent one in time?

    When you're doing the restore, particularly through the GUI,...


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

    jcrawf02 (6/1/2012)


    or a dismembered starfish

    Noooo! Not more starfish!


    - 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: Mixed 2k5 and 2k8 environment and SSIS drivers

    Awesome to hear, thanks everyone. I'll make sure we can swap up to the Native Client 10.


    - 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: What motivates those of you who answer questions?

    For me it started because I was getting involved in a topic and got pushed over to another topic and then started browsing a third one in the middle 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: Looking for Work in SQL Server

    Thanks for the kind words Myles and I'm glad it could help.

    just_myles (5/28/2012)


    Anyway ranting aside, I believe your article was very informative for a struggling dude like me, and 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: sp_getapplock useful?

    sp_getapplock is a simple way to make sure external calls don't end up stepping on each other during a shared usage.

    Under most circumstances I've used to to make sure 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: Subreports not accepting parameters as expected

    Chad Crawford (5/24/2012)


    I don't have the answer, but did you try outputing the 1->2 values on report 1 to verify you are getting the results expected and display 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: Subreports not accepting parameters as expected

    I've created my own workaround but I still don't know what the problem was with the direct entry parameters above.

    My workaround was to alter the PK generating script in Layer...


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

    SSRS 2k5 assistance requested by me. I've got parameters that just won't behave. I could use a hand if any of you have both the experience and 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?

    Lynn Pettis (5/23/2012)


    AAARRRRRGGGGGGG!!!!!!!

    Really, he just needs to go away. He isn't helpful at all.

    Is it sad that not only do I know the person you're talking about, but 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: Best way to quickly discern table relationships?

    Personally, I will usually fire up a trace against the database and goof off with a particular component of the environment. From there, I'll see what procs are called...


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


    Evil Kraig F (5/23/2012)


    This isn't a psychological experiment unless you're trying to determine the psychosis of a Bronco's fan in light of the fact that...


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