Forum Replies Created

Viewing 15 posts - 7,231 through 7,245 (of 13,877 total)

  • RE: The Hidden Trigger

    But beware: No multi-record changes! (and that limits the scope of colleagues I can delegate to rather much...!)Hehe

    Why not? Properly written triggers can handle multi-row changes with no problem.

    April 18, 2016 at 8:05 am

    #1872767

  • RE: Visual Studio 2012 stops working on project switch

    That sounds annoying.

    Have you tried sfc and doing a repair install on your VS installation?

    April 18, 2016 at 6:19 am

    #1872717

  • RE: The Hidden Trigger

    Phil Factor (4/18/2016)

    I used to think it was just me who forgot about triggers I'd written just a short while beforehand. It is just like stepping on a rake in...

    April 18, 2016 at 5:48 am

    #1872710

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (4/15/2016)

    Phil Parkin (4/15/2016)

    GilaMonster (4/15/2016)

    Phil Parkin (4/15/2016)

    Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!

    I'm going to have to steal "Don't have a clue...

    April 15, 2016 at 3:16 pm

    #1872526

  • RE: Are the posted questions getting worse?

    GilaMonster (4/15/2016)

    Phil Parkin (4/15/2016)

    Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!

    I'm going to have to steal "Don't have a clue how to optimize this...

    April 15, 2016 at 2:57 pm

    #1872523

  • RE: Are the posted questions getting worse?

    Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!

    April 15, 2016 at 11:23 am

    #1872436

  • RE: Performance issue with Query

    T.Ashish (4/15/2016)

    This is generated output. Actual script is like

    case when

    ...

    April 15, 2016 at 10:47 am

    #1872414

  • RE: Understand Sharepoint

    renato.afonso (4/15/2016)

    Sorry, rephrasing: creating indexes on the sharepoint database directly, can do more harm than good.

    What sort of harm do you have in mind?

    April 15, 2016 at 9:49 am

    #1872398

  • RE: Loading files in parallel

    Jez-448386 (4/15/2016)

    The OP already has a SSIS package that loads 140+ files sequentially.

    I doubt that there are 140+ separate tasks I guess that this has already been solved.

    Jez

    You mean this?

    richardmgreen1...

    April 15, 2016 at 9:33 am

    #1872395

  • RE: Order by a CASE statment order

    Kazmerelda (4/15/2016)

    Well my query even with the CASE in there is now running in 3 seconds versus 25 so thank you so much for your pointers there.

    I will battle...

    April 15, 2016 at 9:16 am

    #1872386

  • RE: Understand Sharepoint

    renato.afonso (4/15/2016)

    --

    Applying indexes in the database may cause more harm than good.

    Can you justify this comment?

    April 15, 2016 at 9:11 am

    #1872385

  • RE: Copy files into dynamically created folders

    vikram25 (4/15/2016)

    Hi all,

    I am desperately in need for this solution. Any help is most welcome as I am new to SSIS.

    I have files (all types) in one folder and I...

    April 15, 2016 at 6:01 am

    #1872292

  • RE: Loading files in parallel

    Jez-448386 (4/15/2016)

    Probably the best solution would be to put all 140+ file names into a queue table and then have 4 separate For Each Loops taking one record at a...

    April 15, 2016 at 3:16 am

    #1872253

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/14/2016)

    Well, apparently I don't write good questions to teach these people things.

    Maybe some of you should write some questions to help people learn how to...

    April 14, 2016 at 12:08 pm

    #1872119

  • RE: Order by a CASE statment order

    Hugo Kornelis (4/14/2016)

    Phil Parkin (4/14/2016)

    Why are you continuing with the implicit conversion from int to string?

    Actually, int has a higher precedence than string, so the implicit conversion should be from...

    April 14, 2016 at 11:10 am

    #1872093

Viewing 15 posts - 7,231 through 7,245 (of 13,877 total)