Forum Replies Created

Viewing 15 posts - 1,891 through 1,905 (of 8,731 total)

  • RE: How to create SSIS package with PowerShell? ProvideComponentProperties() error

    Dmitriy Burtsev (11/11/2016)

    For production environment we prefer script solution to compiled executable.

    So, you'll be asking MS for the source code for DTExec? That's the compiled executable needed.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 11, 2016 at 7:43 am

    #1911906

  • RE: Need assistance with Dynamic SQL

    Here's a safe option for you:

    DECLARE

    @DBName NVARCHAR(25) = 'CRHC',

    @BegDate DATE = '9/1/2016',

    @EndDate DATE = '9/1/2016',

    @sql NVARCHAR(MAX)

    SELECT @sql = N'USE ' + QUOTENAME( db.name) + ';

    SELECT...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 10, 2016 at 12:30 pm

    #1911759

  • RE: How to optimize this sql query with 290 columns

    Quick thought, return less columns. Why or when will you ever need all those columns and all those rows?

    Also, do not use ISNULL, use WHERE (Column50 = 1 OR Column50...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 10, 2016 at 11:25 am

    #1911737

  • RE: TSQL Formatting tool?

    I've tried Poor Man's T-SQL Formatter[/url] and ApexSQL Refactor which gave me good results to organize messy code, but won't do everything I wanted.

    They're good, but you should try...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 10, 2016 at 10:43 am

    #1911725

  • RE: Benefits of SQL 2014/2016 over 2005 ??

    This might help: http://download.microsoft.com/download/8/A/2/8A2BC8C5-BBA0-4A9C-90BC-AC957D3454D9/SQL_Server_2016_Editions_datasheet.pdf

    The improvement on window functions and error handling.

    Native compressed backups, which would speed up your maintenance process.

    Extended events to mostly replace traces.

    New cardinality estimator.

    Improved security and...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 10, 2016 at 10:26 am

    #1911716

  • RE: Benefits of SQL 2014/2016 over 2005 ??

    Eirikur Eiriksson (11/10/2016)

    homebrew01 (11/10/2016)

    Eirikur Eiriksson (11/10/2016)

    Think this is the wrong question, should be "what are the justifications for running an unsupported version of SQL Server"

    😎

    Doesn't cost any money ?? ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 10, 2016 at 10:15 am

    #1911712

  • RE: Problems joinning tables using "with".

    a_car11 (11/10/2016)

    I am trying to show where I am having the issue, I need to do a join on the "temptable" table to get the value of ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 10, 2016 at 8:41 am

    #1911684

  • RE: Today's Random Word!

    Ed Wagner (11/10/2016)

    Brandie Tarvin (11/10/2016)

    djj (11/10/2016)

    BWFC (11/10/2016)

    djj (11/10/2016)

    Grumpy DBA (11/10/2016)

    Ed Wagner (11/10/2016)

    djj (11/10/2016)

    Grumpy DBA (11/9/2016)

    Manic Star (11/9/2016)

    Elephant

    Cage

    Claustrophobia

    Panic

    (at the) Disco

    Dead

    Parrot

    Pirate

    Patch

    Vulnerability

    exhaust port

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 10, 2016 at 8:02 am

    #1911672

  • RE: check if record exists then update else insert

    Here's an example:

    CREATE TABLE StgTable(

    Id int,

    Seq int,

    name varchar(10),

    company varchar(10)

    );

    INSERT INTO StgTable

    VALUES

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 9, 2016 at 2:53 pm

    #1911506

  • RE: How to create SSIS package with PowerShell? ProvideComponentProperties() error

    Why do you want to create an SSIS package from Powershell?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 9, 2016 at 2:02 pm

    #1911495

  • RE: Today's Random Word!

    Revenant (11/9/2016)

    djj (11/9/2016)

    Ed Wagner (11/9/2016)

    Luis Cazares (11/9/2016)

    Ed Wagner (11/9/2016)

    djj (11/9/2016)

    Eirikur Eiriksson (11/9/2016)

    Ed Wagner (11/9/2016)

    DamianC (11/9/2016)

    snowman

    Frosty

    Trumped

    Thump

    Win

    Wine

    Cheese

    Crackers

    Fire

    Air

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 9, 2016 at 10:05 am

    #1911448

  • RE: How to Pass Output Parameter Store Procedure Value to input to another SP

    Here's an example:

    CREATE PROCEDURE ProcedureWithOutputParam(

    @OutputParam int OUTPUT

    )

    AS

    SET @OutputParam = 5;

    GO

    CREATE PROCEDURE ProcedureWithInputParam(

    @Param int

    )

    AS

    SELECT @Param AS Parameter;

    GO

    DECLARE @Parameter int = NULL;

    EXEC ProcedureWithOutputParam...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 9, 2016 at 9:15 am

    #1911428

  • RE: Edit a SSIS pakcage without Visual Studio

    You need to have Business Intelligence Development Studio (BIDS) or SQL Server Data Tools installed, depending if it 2008 or 2012+.

    These are part of the SQL Server installation, as long...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 9, 2016 at 8:44 am

    #1911418

  • RE: Need advice with large stored procedure

    If it's not using dynamic sql, you can start by using sys.sql_expression_dependencies and sys.sql_dependencies

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 9, 2016 at 7:54 am

    #1911412

  • RE: Today's Random Word!

    Ed Wagner (11/9/2016)

    djj (11/9/2016)

    Eirikur Eiriksson (11/9/2016)

    Ed Wagner (11/9/2016)

    DamianC (11/9/2016)

    snowman

    Frosty

    Trumped

    Thump

    Win

    Wine

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 9, 2016 at 7:02 am

    #1911404

Viewing 15 posts - 1,891 through 1,905 (of 8,731 total)