Forum Replies Created

Viewing 15 posts - 8,086 through 8,100 (of 13,882 total)

  • RE: Redeployment of the same project with environments, variables and ssis project parameters

    HookSqlDba7 (9/28/2015)

    Thanks Phil for being so thorough with your responses. Btw, question 4 was listed at the end of question 3.

    Ah yes, I somehow missed the number but still managed...

    September 28, 2015 at 8:45 am

    #1829906

  • RE: Redeployment of the same project with environments, variables and ssis project parameters

    1) At this point, should the DBA create an environment (and variable) or modify an existing environment (and variable) to accommodate or link to the new project parameter.

    When packages...

    September 28, 2015 at 5:09 am

    #1829829

  • RE: t-sql 2012 isnull

    Luis Cazares (9/25/2015)

    "Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime."

    --

    I like this version:

    Give a...

    September 25, 2015 at 11:34 am

    #1829591

  • RE: Query Performance

    mitzyturbo (9/25/2015)

    Hi guys

    I'm running a simple select query that is running slowly. I've reproduced the performance problem (query takes around 50 seconds). However, if I open another query window and...

    September 25, 2015 at 8:49 am

    #1829503

  • RE: Preference of LEFT JOIN <table> WHERE ... IS NULL vs. NOT EXISTS ( ... )

    This topic has come up many times in the past and usually the NOT EXISTS() version is preferred purely on the basis of its better performance.

    But that is not to...

    September 25, 2015 at 12:19 am

    #1829362

  • RE: Case statement troubles.

    aldous.chris (9/24/2015)

    Hi All,

    I am having trouble with a certain query - being the only SQL resource in my company, I do not have anyone to confirm or deny my...

    September 24, 2015 at 4:49 am

    #1829074

  • RE: SQL in SSIS

    You've been here long enough to know not to cross-post. Replies here please.

    September 24, 2015 at 2:01 am

    #1829045

  • RE: Delete Columns from TSV

    Jeff Moden (9/23/2015)

    @Phil,

    So does that mean that you have to manually click on 480 columns in step 6?

    Good question, and one which also went through my mind as I was...

    September 24, 2015 at 1:33 am

    #1829037

  • RE: Default value for boolean parameter

    Kristen-173977 (9/23/2015)

    or @YesNo IS null)

    I wish that SQL Server have a mode/flag/option that would moan about things like this ... on the occasions that they take hours to find the...

    September 23, 2015 at 5:38 am

    #1828731

  • RE: SSDT Not Updating Database

    Chris Wooding (9/23/2015)

    Yes, we've noticed that it frequently puts superfluous brackets around the default expression in the script so that the resulting constraint in the database doesn't match the project...

    September 23, 2015 at 1:57 am

    #1828676

  • RE: Delete Columns from TSV

    demin99 (9/22/2015)

    I have a TSV File which has around 500+ columns.I want to import data from 20 columns (among 500) using SSIS. How should I handle this in SSIS..?

    Appreciate...

    September 23, 2015 at 12:19 am

    #1828659

  • RE: need help to tune a query

    ekant_alone (9/22/2015)

    Thanks Phil

    U r the best. I dont know what i was thinking when i wrote that query.over thinking i guess.

    It worked.

    Thank you all.

    Glad to help. But please...

    September 22, 2015 at 11:56 am

    #1828519

  • RE: need help to tune a query

    If you take all those LEFT JOINs away, do you get a different result?

    I mean, what happens if you try this?

    select count(*)

    from unit u

    join ...

    September 22, 2015 at 8:25 am

    #1828421

  • RE: SSDT Not Updating Database

    Sorry i should have been more clear , with not affected I mean the schema is not affected at the time of comparison , not deployment. Essentially

    User 1 @ 0...

    September 21, 2015 at 10:29 am

    #1828153

  • RE: Run SQL Script within a table/string and output results to file

    John Mitchell-245523 (9/21/2015)

    Phil

    I think it would be simpler. With Execute Process, you can use sqlcmd to execute the script from wherever it is. With another Execute SQL, you'd...

    September 21, 2015 at 8:01 am

    #1828087

Viewing 15 posts - 8,086 through 8,100 (of 13,882 total)