Forum Replies Created

Viewing 15 posts - 46 through 60 (of 153 total)

  • RE: data load performance

    arkiboys (8/17/2016)

    Hello,

    using a combination of ssis and C#, we are placing file data into sql server tables.

    The files contain around 70 million of rows...

    We can not use bulk insert as...

    August 17, 2016 at 7:25 am

    #1895910

  • RE: upgrading sql 2012 to sql 2014 on 2 node active/passive cluster best practices

    JP10 (8/3/2016)

    Problem is in dev, test and staging these are stand alone servers and in PROD they are clustered does that make a difference?

    Not from a testing standpoint. a...

    August 8, 2016 at 1:13 pm

    #1894421

  • RE: BI Question (Execute Process Tasks not running in SQL Agent)

    charles.russell (8/8/2016)

    I am sorry I don't see a Business Intelligence forum for 2008. I have several SSIS packages that launch external programs either batch programs for things like SFTP...

    August 8, 2016 at 12:15 pm

    #1894411

  • RE: simple date function concept

    Luis Cazares (8/8/2016)

    And now you have 2 threads with the same question and very similar answers. You only divided the replies and confused people on what version you're using.

    http://www.sqlservercentral.com/Forums/Topic1807873-3412-1.aspx

    hrmm I...

    August 8, 2016 at 8:02 am

    #1894342

  • RE: simple date function concept

    Anandkumar-SQL_Developer (8/8/2016)

    Hi Friends,

    please some one help me how can i get my Expected output.?

    Sample Input...

    August 8, 2016 at 7:53 am

    #1894338

  • RE: Substring from RIGHT

    Jeff Moden (8/3/2016)

    Smendle (8/3/2016)

    Jeff Moden (7/20/2016)

    Smendle (7/20/2016)

    Jeff Moden (3/4/2016)

    John Mitchell-245523 (3/4/2016)

    REVERSE the string, use SUBSTRING, and then REVERSE it again.

    John

    Got code?

    Something like this?

    With MyCTE(val)

    AS

    (

    SELECT '9.0.0832.1032' UNION ALL --need to get...

    August 5, 2016 at 9:08 pm

    #1894175

  • RE: How do we avoid junk in the VARCHAR fields ?

    mw112009 (8/1/2016)

    This is my update statement.

    UPDATE [MEMBER].[IMP_MEMBER_INT]

    SET

    [ContactLastName] = CASE WHEN LEN(ISNULL(LNAME,'')) > 1 THEN left(ltrim(rtrim(LNAME)),60) ELSE @DefOfNull END

    ,[ContactFirstName] = CASE WHEN LEN(ISNULL(FNAME,'')) > 1 THEN...

    August 3, 2016 at 8:50 am

    #1893514

  • RE: Issue with slow find and replace function code from a lookup table can I do this in a better way

    Please provide the following to help us help you:

    Table Definition:

    i.e.

    CREATE TABLE [dbo].[Dim_Colour](

    [colour] [varchar](30) NULL,

    [model_number] [varchar](30) NULL,

    [commission_group] [varchar](30) NULL,

    [custom_1] [varchar](30) NULL,

    [custom_2] [varchar](30) NULL,

    [custom_3] [varchar](30) NULL,

    [custom_4] [varchar](30) NULL,

    [custom_5] [varchar](30) NULL,

    [product_name] [varchar](30) NULL,

    [description]...

    August 3, 2016 at 7:23 am

    #1893477

  • RE: Substring from RIGHT

    Jeff Moden (7/20/2016)

    Smendle (7/20/2016)

    Jeff Moden (3/4/2016)

    John Mitchell-245523 (3/4/2016)

    REVERSE the string, use SUBSTRING, and then REVERSE it again.

    John

    Got code?

    Something like this?

    With MyCTE(val)

    AS

    (

    SELECT '9.0.0832.1032' UNION ALL --need to get the 32 (one...

    August 3, 2016 at 6:26 am

    #1893457

  • RE: Moving Distributor over to new server

    navtec (8/3/2016)

    Hi,

    I currently have snapshot replication running and my publisher and distributor both sit on the same server.

    I want to move my distributor to another server.

    How can I do this?

    Is...

    August 3, 2016 at 6:16 am

    #1893453

  • RE: SCD2 processing - want to carry forward data from closed out record

    Simple

    Select myvar,sk,recnum,

    Case Recnum

    When 0 Then sk Else Recnum

    End as ModRecnum

    From tmp.mytable

    August 3, 2016 at 6:10 am

    #1893450

  • RE: HeartBeat Failure

    If your VMs are saturated CPU wise and you have Hyperthreading enabled I would consider disabling it.

    This article explains why and is 2005 tagged but applies to all versions of...

    August 2, 2016 at 1:05 pm

    #1893335

  • RE: Merge Statement using CTE

    fergfamster (7/22/2016)

    Thank you for the effort and trials...! The Temp Table is 23 Million but the Primary table is 23 billion which i why i thought the date scan would...

    July 22, 2016 at 11:45 am

    #1891649

  • RE: Merge Statement using CTE

    fergfamster (7/21/2016)

    Thanks, I dont really want to post 15 files you guys need to review to get an answer. ill figure it out.

    Because I have very little experience with MERGE...

    July 22, 2016 at 11:04 am

    #1891643

  • RE: Find Min(), Max() value from a table

    I'm still amazed at the requirement to get better performance when you are already seeing performance that is equivalent to an eye-blink.:crazy:

    July 21, 2016 at 8:48 am

    #1891350

Viewing 15 posts - 46 through 60 (of 153 total)