Forum Replies Created

Viewing 15 posts - 17,911 through 17,925 (of 59,069 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/8/2016)

    Anyone have any insight on SQL 2012 jobs failing due to SSIS access denied problems?

    We've been working on this for almost 8 hours now and we've started to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 8, 2016 at 8:35 am

    #1870819

  • RE: Optimize very frequent running SP

    EasyBoy (4/8/2016)

    Thanks all for your inputs. I will try all recommendation on our test environment and share my outcomes with you guys.

    I could really use the output from the queries...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 8, 2016 at 8:34 am

    #1870818

  • RE: Optimize very frequent running SP

    First, awesome job of posting what we need to help. Thanks for taking the time.

    What do the following queries return, please... (not sure I did the 2nd query right...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 7, 2016 at 10:09 pm

    #1870701

  • RE: tempdb filled from ETL process

    To add to what Sergiy posted, the data in the VARCHAR columns may have a serious but easy to fix problem. They may be filled with trailing spaces and...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 7, 2016 at 6:58 pm

    #1870693

  • RE: Processing strings.

    ben.brugman (4/7/2016)

    patrickmcginnis59 10839 (4/7/2016)

    was anybody able to get a tally table looking solution to work with the delimiter inside quotes exclusion? its obviously easy with a loop, but was curious...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 7, 2016 at 9:17 am

    #1870543

  • RE: Where to start?

    maylar (4/7/2016)

    So far the online docs have been worthless. I don't need to learn about databases, [font="Arial Black"]I just need to understand how to navigate within this admin tool[/font]. I've...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 7, 2016 at 7:40 am

    #1870474

  • RE: Help required in query.

    amitsingh308 (4/7/2016)

    Create table Script is as under:

    Create table OrdersDetails(OrderNo varchar(30),ItemNo Varchar(20),ItemName Varchar(50))

    insert script is as under:

    Insert into OrdersDetails (OrderNo,ItemNo,ItemName) Values('12231','1','sdfasfasd')

    Insert into OrdersDetails (OrderNo,ItemNo,ItemName) Values('12231','2','sdfasfasdas2')

    Insert into OrdersDetails (OrderNo,ItemNo,ItemName) Values('12231','1','sdfasfasd')

    Insert into OrdersDetails...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 7, 2016 at 7:27 am

    #1870464

  • RE: Processing strings.

    That's how many towers start out. Simple project. Hope it doesn't bite you or the people that follow you in the long run.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 6, 2016 at 4:18 pm

    #1870328

  • RE: Creating dynamic master insert proc with identity column needing to be omited

    jpgillum (4/6/2016)

    ------------------------------------------------------

    [font="Arial Black"]Do the required processing and load the #case_tmpTable

    [/font]Then do the insert into the target table without specifying the column names.

    I can now use the Select *

    ------------------------------------------------------

    I'm curious......

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 6, 2016 at 3:44 pm

    #1870326

  • RE: Help required in query.

    amitsingh308 (4/6/2016)

    Please help me.

    Help us help you. Please see the first link under "Helpful Links" in may signature line below.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 6, 2016 at 2:39 pm

    #1870319

  • RE: Tempdb files

    ramyours2003 (4/6/2016)

    I have 32 processors in my server , can we create more than 8 temp files , if yes how ?

    To be honest, this is an advanced...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 6, 2016 at 2:37 pm

    #1870316

  • RE: Are the posted questions getting worse?

    Phil Parkin (4/6/2016)

    Jeff Moden (4/6/2016)

    Phil Parkin (4/6/2016)

    Lynn Pettis (4/5/2016)

    And now the attitude arrives.

    Check out the most recent 'I am proficient ...' comment. I nearly regurgitated my breakfast cereal.

    Link? I'd...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 6, 2016 at 8:15 am

    #1870188

  • RE: Error converting data type varchar to numeric

    sks_989 (4/6/2016)

    Thanks for the performance thing if i put into temp table and then join to that table it should be good on performance wise.

    Eventually, it won't be. While...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 6, 2016 at 7:54 am

    #1870178

  • RE: Are the posted questions getting worse?

    Phil Parkin (4/6/2016)

    Lynn Pettis (4/5/2016)

    And now the attitude arrives.

    Check out the most recent 'I am proficient ...' comment. I nearly regurgitated my breakfast cereal.

    Link? I'd just like to see.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 6, 2016 at 7:43 am

    #1870167

  • RE: Processing strings.

    patrickmcginnis59 10839 (4/5/2016)

    But the idea that this construct is some sort of "tower of babel" is just silly in my opinion.

    I've seen some pretty bad things in various shops, much...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 5, 2016 at 9:05 pm

    #1870037

Viewing 15 posts - 17,911 through 17,925 (of 59,069 total)