Forum Replies Created

Viewing 15 posts - 7,786 through 7,800 (of 13,876 total)

  • RE: Unarchive records

    Looks like a typo.

    arc.Call.ID = Pri.Call_ID

  • RE: How to Execute SQL Task from Stored Proc & Then Query *THOSE* Results?

    brad.mccollum (12/23/2015)


    I'm working on an SSIS pkg. that I need to run a stored procedure to return a pretty large results set. I'm assuming this will need to be...

  • RE: Dynamic Query issue

    Re1 (12/23/2015)


    Hi guys,

    I am doing one POC. I am trying to generate and execute a dynamic sql. In that dynamic sql i have to many replace functions.At the time of...

  • RE: Clustered PK and Nonclustered Index on Same Column

    lmarkum (12/22/2015)


    I have come across several tables recently where the clustered PK on Column (X), for example, is also been duplicated as a nonclustered index. When I look at...

  • RE: Are the posted questions getting worse?

    Sean Lange (12/22/2015)


    Lynn Pettis (12/22/2015)


    Silver Spoon really doesn't seem to care about learning anything. Just the answer, that's all he is interested in.

    I really hope there is someone else...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (12/22/2015)


    Phil Parkin (12/22/2015)


    Sean Lange (12/22/2015)


    Phil Parkin (12/22/2015)


    It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-D

    I prefer making sawdust as my form of therapy.

    Plugging...

  • RE: sql server 2014 becomming non responsive

    Are you suggesting i use the DAC to get into the sql intance to identify whats killing it while it's happening?

    Just an idea which may help your troubleshooting, yes.

  • RE: Are the posted questions getting worse?

    Sean Lange (12/22/2015)


    Phil Parkin (12/22/2015)


    It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-D

    I prefer making sawdust as my form of therapy.

    Plugging in my guitar and...

  • RE: sql server 2014 becomming non responsive

    Snargables (12/22/2015)


    We have a few instances in the past few days where sql has become unresponsive. The cpu gets to 55% then we cant access it. In the logs right...

  • RE: Incremental Loading using SSIS

    RonKyle (12/19/2015)


    RonKyle - why won't you use stored procedures to do a final insert?

    I do use stored procedures for the final insert in the sense that there is a...

  • RE: Load date time field to date field

    Have a look here.

    This gives you an idea of data type mappings between SQL Server and SSIS.

    The implication of the link is that you should attempt to get your input...

  • RE: Are the posted questions getting worse?

    It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-D

  • RE: Rollback transaction in SSIS

    Sushant Yadav (12/21/2015)


    Hi All,

    Need your help in below scenario.

    We have SSIS packages which involves Oracle and SQL servers. We have logic like when data is transferred to Oracle from SQL...

  • RE: Cast as Numeric

    I was trying to divide by 0

    Let me advise you against that. You'll get an error.

  • RE: Database Design Question

    joshdbguy (12/21/2015)


    I have some developers that want a bunch of fields added to an existing table (it's fairly new) including a GUID field (UUID). My recommendation was that instead of...

Viewing 15 posts - 7,786 through 7,800 (of 13,876 total)