Forum Replies Created

Viewing 15 posts - 16,786 through 16,800 (of 59,101 total)

  • RE: Backup Restoring - Insufficient free space

    Minnu (9/21/2016)

    Hi Team,

    Restoring SQL Server database from one server to another.

    Actual Database size is: 14.3 GB

    But while restoring getting below error.

    The database required 127533776896 additional free bytes, while only 47082643456...

    --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)

    September 21, 2016 at 4:14 pm

    #1902312

  • RE: Server Drive Configuration

    Terry B-214928 (9/21/2016)

    Hello - We will be setting up a SQL server to host our accounting system databases. There will be around 90 users accessing the system.

    The server has...

    --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)

    September 21, 2016 at 4:09 pm

    #1902311

  • RE: Processing Flat file with no delimiters

    waxb18 (9/21/2016)

    Morning All,

    I've received a flat file which needs to processed into a SQL table, the only problem being that the file has no column delimiters hence when imported...

    --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)

    September 21, 2016 at 3:04 pm

    #1902302

  • RE: How to use BCP to Import Data from .xls or .csv files

    You don't need to use XP_CmdShell and BCP to import unless you're working around a privs issue.

    And, to skip the headers, use the "First Row" option.

    --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)

    September 21, 2016 at 2:56 pm

    #1902297

  • RE: how to convert navarchar to datetime

    A "SendDate" as an NVARCHAR(4000)? Now that's a table that probably needs to be redesigned a bit. 😉

    --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)

    September 21, 2016 at 2:51 pm

    #1902296

  • RE: One to Many relations

    If you want to change a photo in one place, do you want the photo to change in all places that it's used?

    --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)

    September 21, 2016 at 2:45 pm

    #1902295

  • RE: Remove duplicates before inserting into destination

    komal145 (9/21/2016)

    The campaignname with date appeneded is duplicates . so , yes to your question.

    example from my table:

    Day10ReminderCampaign2016_09_16_01:43:05

    Day10ReminderCampaign2016_09_17_01:44:01

    Day10ReminderCampaign2016_09_18_01:43:59

    Day10ReminderCampaign2016_09_19_01:45:42

    Day10ReminderCampaign2016_09_20_01:22:18

    Day10ReminderCampaign2016_09_16_01:43:05

    Day10ReminderCampaign2016_09_16_01:43:05

    Day3ReminderCampaign2016_09_16_02:24:16

    Day3ReminderCampaign2016_09_16_02:24:16

    So the eventual problem hasn't been solved. There's no guarantee that two...

    --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)

    September 21, 2016 at 1:48 pm

    #1902287

  • RE: The 10X Programmer

    Steve Jones - SSC Editor (9/21/2016)

    10X doesn't mean more code. It doesn't mean more functions or features. It doesn't mean 1/10th the time. It means 10x in terms of effectiveness...

    --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)

    September 21, 2016 at 1:43 pm

    #1902284

  • RE: SP inserts into table

    Ken McKelvey (9/21/2016)

    As mentioned, this is an horrible design.

    If you have to live with an app which uses it, I would alter it so the parameters are logged and a...

    --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)

    September 21, 2016 at 1:38 pm

    #1902282

  • RE: The 10X Programmer

    djackson 22568 (9/21/2016)

    Jeff Moden (9/21/2016)

    Steve Jones - SSC Editor (9/21/2016)

    Jeff Moden (9/19/2016)

    To be honest, I've yet to run into a supposed 10X programmer that's worth their salt.

    Look in the mirror

    Thank...

    --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)

    September 21, 2016 at 1:23 pm

    #1902279

  • RE: The 10X Programmer

    Steve Jones - SSC Editor (9/21/2016)

    Jeff Moden (9/19/2016)

    To be honest, I've yet to run into a supposed 10X programmer that's worth their salt.

    Look in the mirror

    Thank you for the compliment...

    --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)

    September 21, 2016 at 12:46 pm

    #1902267

  • RE: Remove duplicates before inserting into destination

    komal145 (9/21/2016)

    Yes. Finally i am able to remove dupes by just getting distinct values from view and inserting into destination.

    What did you do about the question I asked? Did...

    --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)

    September 21, 2016 at 12:40 pm

    #1902263

  • RE: Remove duplicates before inserting into destination

    komal145 (9/21/2016)

    My source has duplicate. Campaignnames appened with sendate dupes.

    So my example also contains dupes. In my reference tables , which comes from view over stage/source table has just campaign...

    --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)

    September 21, 2016 at 8:27 am

    #1902187

  • RE: The Danger of xp_cmdshell

    Ed Wagner (9/21/2016)

    It's all about picking the right tool for the job. The more tools you have in your toolbox, the more options you have available. If you...

    --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)

    September 21, 2016 at 6:21 am

    #1902133

  • RE: Remove duplicates before inserting into destination

    First, with 253 posts, you should know by now to post readily consumable data to get better answers quicker. Please read and heed the first link under "Helpful Links"...

    --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)

    September 21, 2016 at 6:15 am

    #1902132

Viewing 15 posts - 16,786 through 16,800 (of 59,101 total)