Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 5,685 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...

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

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

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

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

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

    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.

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

    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,...

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

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

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

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

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

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

    August 5, 2011 at 2:28 pm

    #1364632

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