Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 5,678 total)

  • RE: Updating text valued(varchar) column with better performance

    bvsc (8/8/2011)

    I agree all of you. I am sorry might not explain you properly.. Please follow this.

    ... snip ...

    The least case I prefer is normalization.. I know it will work...

    - 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

    August 8, 2011 at 4:21 pm

    #1365580

  • RE: Linked Server error

    MSDTC (MicroSoft Distributed Transaction Coordinator) sounds like it wasn't activated on the foreign system. Because you're inserting locally but the data is foreign it wants to open the transaction...

    - 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

    August 8, 2011 at 4:15 pm

    #1365579

  • RE: Transfer ssis package from location to other

    rocky_498 (8/8/2011)

    Guys need help/advise,

    I created Package that has 12 data flows in all data flows I am using SCD Transformation. This package is in my local machine. I want...

    - 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

    August 8, 2011 at 4:14 pm

    #1365577

  • RE: Using SSIS

    kishoremania (8/8/2011)

    I reformed the question for understanding easily. Here it is..

    This helps.

    I have 2 databases in different sql servers. One is my source database with plain tables(staging), other is my...

    - 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

    August 8, 2011 at 4:09 pm

    #1365574

  • RE: Hidden RBAR: Counting with Recursive CTE's

    Say Jeff, Excellent examples and walkthroughs as always to not only understand that it's sub-optimal, but WHY, and WHERE, and how to prove it to both yourself and your boss...

    - 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

    August 8, 2011 at 1:41 pm

    #1365490

  • RE: Are the posted questions getting worse?

    GilaMonster (8/8/2011)

    I suspect he was answering Kraig's question 'So who are you?'

    Of course, anyone who's watched Season 2 of Babylon 5 knows that's completely the wrong answer (and it's 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

    August 8, 2011 at 12:45 pm

    #1365467

  • RE: Are the posted questions getting worse?

    And I fail.

    He's copy/pasted my name in the quote and still can't get it right. I don't have high hopes.

    - 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

    August 5, 2011 at 5:26 pm

    #1364706

  • RE: SQL server vs Access in the job market

    Major paycut and limitations as to what you can do with MS Access.

    It takes time to be an expert in either, honestly. You're right, MSAccess is a powerful tool...

    - 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

    August 5, 2011 at 4:59 pm

    #1364703

  • RE: Are the posted questions getting worse?

    GilaMonster (8/5/2011)

    Anyone want to 'help' out here? http://www.sqlservercentral.com/Forums/Topic1155386-391-1.aspx

    p.s. if you go to his blog, several posts have pieces copy-paste from a Microsoft webpage, no attribution

    Threw a hat into the ring,...

    - 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

    August 5, 2011 at 4:55 pm

    #1364702

  • RE: How to Become MVP?

    @SQLFRNDZ (8/5/2011)

    Thank you for the information.

    I was just posted this topic because I see this MVP tag on most sites and blogs of experts and I wonder why...

    - 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

    August 5, 2011 at 4:51 pm

    #1364701

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/5/2011)

    Craig Farrell (8/5/2011)

    WayneS (8/5/2011)

    Craig Farrell (8/5/2011)

    A moment of Friday Humor...

    Time to optimize, perhaps?

    You know, for a not-so-small amount, I can do things like optimize queries. 😉

    LOL, don't think 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

    August 5, 2011 at 3:25 pm

    #1364669

  • RE: Delete ON Self Join

    Sean Lange (8/5/2011)

    On the contrary, I think your explanation was pretty much spot on. I was just trying to take your example to demonstrate how the OP was using NULL...

    - 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

    August 5, 2011 at 3:12 pm

    #1364658

  • RE: Delete ON Self Join

    Sean Lange (8/5/2011)

    Craig Farrell (8/5/2011)

    Sean Lange (8/5/2011)

    cfradenburg (8/5/2011)

    Two ways to go about this. One is to set "on delete cascade" on the foreign key. ...

    Small data set 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

    August 5, 2011 at 3:01 pm

    #1364656

  • RE: Are the posted questions getting worse?

    WayneS (8/5/2011)

    Craig Farrell (8/5/2011)

    A moment of Friday Humor...

    Time to optimize, perhaps?

    You know, for a not-so-small amount, I can do things like optimize queries. 😉

    LOL, don't think I didn't review 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

    August 5, 2011 at 3:01 pm

    #1364655

  • RE: Delete ON Self Join

    Sean Lange (8/5/2011)

    cfradenburg (8/5/2011)

    Two ways to go about this. One is to set "on delete cascade" on the foreign key. ...

    Small data set or not, you're likely 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

    August 5, 2011 at 2:28 pm

    #1364632

Viewing 15 posts - 2,716 through 2,730 (of 5,678 total)