Forum Replies Created

Viewing 15 posts - 24,631 through 24,645 (of 59,099 total)

  • RE: Volunteering to gain SQL experience

    pietlinden (1/26/2014)

    It's a health care company, so they do a lot of data importing, I assume.

    The client stated that the candidate must understand Identity in SQL. They need to know...

    --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 3:15 pm

    #1683400

  • RE: QA and DB Design team sleeping in same "bed"?

    Personally, I think having the QA Team in design meetings is one of the most valuable things that can be done in a project provided that a true bi-directional dialog...

    --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 12:38 pm

    #1683386

  • RE: View vs sp vs functions

    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, I have to ask...

    --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 12:16 pm

    #1683384

  • RE: View vs sp vs functions

    bitbucket-25253 (1/25/2014)

    1). A view is a virtual table that consists of columns from one or more tables. Though it is similar to a table, it is not stored in...

    --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 12:08 pm

    #1683383

  • RE: View vs sp vs functions

    To add to what the others have already stated...

    If you write a function as an iTVF or INLINE Table Valued Function, it will work just like a View except for...

    --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 12:01 pm

    #1683382

  • RE: Value of @@DBTS / timestamp column

    vip.blade (1/26/2014)

    Hi,

    I have a question regarding the timestamp type in SQL Server. As far as I know the timestamp column holds an ever increasing number (every update or insert increments...

    --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 11:54 am

    #1683381

  • RE: Volunteering to gain SQL experience

    pietlinden (1/26/2014)

    "Believe it or not, SQL Saturdays are one of the best places to network."

    Actually, there were a bunch of recruiter types there last week (#272). Someone actually...

    --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 11:42 am

    #1683380

  • RE: How to use scalar function without WHILE

    vip.blade (1/19/2014)

    I have a scalar function, which calculates the similarity of two strings.

    Hi.

    Would you post that function, please? I could use something like that and I might be able...

    --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 11:40 am

    #1683379

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

    Express12 (1/26/2014)

    Looking for T-SQL command to delete all subdirectories (and their files) within a master directory --- in a single invocation.

    Example, I need to delete ALL subdirectories (and their files)...

    --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 11:38 am

    #1683378

  • RE: Optimize Update Statement

    wit_jp2001 (1/24/2014)

    Thanks,

    I will try out the new query this afternoon. Just so that eveyone knows this process is to update the 1st SKU with the heaviest SKU. ...

    --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 25, 2014 at 6:03 pm

    #1683357

  • RE: Optimize Update Statement

    wit_jp2001 (1/24/2014)

    Chris - Thanks works great.

    If your final code is still using an "=" sign for a NULL test, then it might not actually be doing what it's supposed 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)

    January 25, 2014 at 5:40 pm

    #1683356

  • RE: Optimize Update Statement

    ChrisM@Work (1/24/2014)

    Same statement rewritten as UPDATE FROM, with nonsense logic commented out:

    While I agree that the commented out code is incorrectly written, I think it should be rewritten with...

    --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 25, 2014 at 5:37 pm

    #1683355

  • RE: Autogrowth, shrink and database performance

    IgorMi (1/25/2014)

    Jeff Moden (1/24/2014)

    IgorMi (1/22/2014)

    1) Yes, you can autogrow for 300 MB, however it's better to go with smaller sizes, let's say 50-70 MBs.

    2) No, you should not shrink. They...

    --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 25, 2014 at 5:09 pm

    #1683354

  • RE: Are the posted questions getting worse?

    Shifting gears a bit, I've seen a trend starting to develop that will define the next wave of performance and memory problems. Even some people that I think have...

    --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 25, 2014 at 4:57 pm

    #1683353

  • RE: How to study for MCSA SQL Server 2012

    rho_pooka (1/25/2014)

    You've solidified my interest!... I'll be at both.

    -Ben

    Take hard-copy resumes, business cards, your laptop with an electronic copy of your resume, and a winning attitude with you. Your...

    --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 25, 2014 at 4:23 pm

    #1683352

Viewing 15 posts - 24,631 through 24,645 (of 59,099 total)