Forum Replies Created

Viewing 15 posts - 24,616 through 24,630 (of 59,102 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (1/27/2014)

    Sometimes I wonder if people really want help.

    "Sample data please"

    "I don't see the point" "It won't be of any benefit"

    "Expected results please"

    "It's not going to help"

    The person that I...

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

    January 27, 2014 at 11:16 pm

    #1683795

  • RE: Volunteering to gain SQL experience

    wolfkillj (1/27/2014)

    Jeff Moden (1/25/2014)

    Also, spend an hour to either sit down and design a simple business card with the area of SQL Server that you'd like to work with on...

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

    January 27, 2014 at 11:05 pm

    #1683794

  • RE: Value of @@DBTS / timestamp column

    Ah, my apologies. I read that the return datatype of @@DBTS is VARBINARY in BOL and didn't consider the source (TIMESTAMP) is 64 bits. Thanks for the correction.

    Guess...

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

    January 27, 2014 at 10:47 pm

    #1683791

  • RE: Query just hangs!

    I haven't checked for all of the columns but the original query had a "Hierarchy" column in it, which is missing from the test data. Considering that the triangular...

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

    January 27, 2014 at 5:25 pm

    #1683765

  • RE: Automatically import csv content into SQL Server

    Deries (1/27/2014)

    Thank you Jeff, Could you or anyone give me a sample code to test it out.

    The link that Luis posted has such sample code in the article.

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

    January 27, 2014 at 4:20 pm

    #1683751

  • RE: Unable to scheule packages

    I guess my question would be, why can't you do this with Windows Authentication and trusted connections?

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

    January 27, 2014 at 4:19 pm

    #1683750

  • RE: need T-SQL to delete ALL subdirectories within a Directory

    Express12 (1/27/2014)

    this script did the trick:

    -- This step will DELETE "ALL" previously gen'd FULL/DIFF/LOG backup files on T: making space for the new Backup files

    --

    -- It is needed as the...

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

    January 27, 2014 at 4:15 pm

    #1683749

  • RE: FizzBuzz

    mister.magoo (1/27/2014)

    So you didn't get them to explain the rules for a successful quirky update then I guess?

    😀

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

    January 27, 2014 at 3:52 pm

    #1683744

  • RE: FizzBuzz

    Shifting gears a bit, in the last 20 interviews that I've conducted, I ask the candidates to wirte code to create and populate a table with all integer values from...

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

    January 27, 2014 at 12:31 pm

    #1683682

  • RE: Automatically import csv content into SQL Server

    Deries (1/27/2014)

    I have a CSV & xls file and I'd like import the data from CSV into SQL server existing table efficiently.

    This process should be done automatically...

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

    January 27, 2014 at 12:22 pm

    #1683678

  • RE: View vs sp vs functions

    The reason why I'm the one doing the interviews is because these particular companies don't just want "butts in seats". They actually want people that know what they're doing...

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

    January 27, 2014 at 7:14 am

    #1683537

  • RE: View vs sp vs functions

    Lynn Pettis (1/26/2014)

    Jeff Moden (1/26/2014)

    zi (1/25/2014)

    Dear Experts

    I want to know differences between views , stored procedures and functions

    And when to choose the appropriate one

    Thanks lot

    Since it was appropriately brought up,...

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

    January 27, 2014 at 6:49 am

    #1683529

  • RE: Scanning all tables for highest ID

    TheSQLGuru (1/26/2014)

    >> FROM sys.identity_columns

    Thanks for that nugget Jeff - almost 45000 man hours working with SQL Server and still learning!! :w00t:

    I'm right there with you, Kevin. I...

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

    January 26, 2014 at 10:08 pm

    #1683416

  • RE: Minimum privileges

    asdsfssd (6/11/2013)

    SQL2000

    What are the minimum privileges / permissions / database roles needed to grant a user (besides granting sysadmin) to:

    1) Create and run DTS packages.

    2) Create, run and review job...

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

    January 26, 2014 at 8:36 pm

    #1683412

  • RE: variable file name in openrowset

    In other words, the OPENROWSET that you've created will need to be converted to Dynamic SQL.

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

    January 26, 2014 at 7:58 pm

    #1683410

Viewing 15 posts - 24,616 through 24,630 (of 59,102 total)