Forum Replies Created

Viewing 15 posts - 4,321 through 4,335 (of 13,874 total)

  • RE: Is combining multiple SQL Server Database and Integration Services projects in one master solution a bad idea?

    Scott In Sydney - Thursday, June 28, 2018 10:58 PM

    Hi All,

    More input on this...

    I ended up using a lot of synonyms based...

    June 29, 2018 at 7:35 am

    #1995805

  • RE: SSDT background themes and configuration manager settings

    richardmgreen1 - Thursday, June 28, 2018 8:35 AM

    Hi Phil

    We use SSDT/Visual Studio to create SSIS packages, stored procedures, etc (so we can...

    June 28, 2018 at 9:08 am

    #1995646

  • RE: SSDT background themes and configuration manager settings

    richardmgreen1 - Thursday, June 28, 2018 7:54 AM

    Hi all

    This is an odd one.
    We've got 2 servers (DEV and PROD) and we have...

    June 28, 2018 at 8:30 am

    #1995632

  • RE: Optimization of sql server big query

    Luis Cazares - Wednesday, June 27, 2018 2:13 PM

    Phil Parkin - Wednesday, June 27, 2018 2:03 PM

    June 27, 2018 at 2:30 pm

    #1995524

  • RE: Optimization of sql server big query

    sgmunson - Wednesday, June 27, 2018 1:57 PM

    I'll go ahead and reformat them all:

    And suddenly, it becomes human-readable!
    But it looks like we're...

    June 27, 2018 at 2:03 pm

    #1995517

  • RE: Is combining multiple SQL Server Database and Integration Services projects in one master solution a bad idea?

    Scott In Sydney - Wednesday, June 27, 2018 7:01 AM

    Phil Parkin - Wednesday, June 27, 2018 5:28...

    June 27, 2018 at 8:02 am

    #1995453

  • RE: Cross Database Permissions: SQL 2005 vs SQL 2016

    Rather than 'FAIL', please post the exact text of the message you see.

    June 27, 2018 at 6:41 am

    #1995429

  • RE: Is combining multiple SQL Server Database and Integration Services projects in one master solution a bad idea?

    Scott In Sydney - Wednesday, June 27, 2018 3:34 AM

    tl;dr:  How do you organize your multiple SSDT projects that comprise a single...

    June 27, 2018 at 5:28 am

    #1995421

  • RE: Optimization of sql server big query

    riccardo 66877 - Tuesday, June 26, 2018 9:43 AM

    Hi then the query I'm running below works correctly but it is very...

    June 26, 2018 at 10:07 am

    #1995318

  • RE: SSIS Double Sending Emails

    I agree with Tim. Put the e-mail tasks after the FEL, with the same Success/Fail precedence constraints.
    You might also like to consider using an Error Handler for the failures.

    June 26, 2018 at 8:24 am

    #1995301

  • RE: Row over partition

    dbman - Tuesday, June 26, 2018 8:00 AM

    I have a large query. I would like to count the number of instances in...

    June 26, 2018 at 8:19 am

    #1995299

  • RE: SQL Standard Edition

    PSB - Monday, June 25, 2018 8:48 AM

    Hi,

     In MSDN, I am not finding a link to download SQL Server standard edition ....

    June 25, 2018 at 8:54 am

    #1995168

  • RE: SSIS: How to load a data from a table to a file, into 50 000 batches (50 000 rows at a time)

    Thom A - Monday, June 25, 2018 5:25 AM

    Duplicate of https://www.sqlservercentral.com/Forums/1970852/SSIS-How-to-load-a-data-from-a-table-to-a-file-into-50-000-batches-50-000-rows-at-a-time. Please direct answers to the other topic.

    Oops ... my apologies,...

    June 25, 2018 at 5:27 am

    #1995119

  • RE: SSIS: How to load a data from a table to a file, into 50 000 batches (50 000 rows at a time)

    sirkinghorse - Monday, June 25, 2018 5:20 AM

    Hi,
    I have a table with 200 000 records, I need to send a file with...

    June 25, 2018 at 5:26 am

    #1995117

    • Viewing 15 posts - 4,321 through 4,335 (of 13,874 total)