Forum Replies Created

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

  • RE: Visual Studio 2015 and SQL Server 2014

    Eirikur Eiriksson (4/18/2016)

    No insight info but have been playing around with 2014 as target server and so far no problem. Note that I've not used any version specific libraries in...

    April 18, 2016 at 10:22 am

    #1872820

  • RE: EXEC XP_CMDShell running in SSMS 2012

    sulman.sqldba (4/18/2016)

    EXEC XP_CMDSHELL 'net use /delete *'

    Need to find out how to feed a "Y" answer into the execution of this command.

    Trying to delete this post!

    Add a /y...

    April 18, 2016 at 10:03 am

    #1872810

  • 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

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