Forum Replies Created

Viewing 15 posts - 18,541 through 18,555 (of 59,072 total)

  • RE: Flag Values Based on Columns

    nm.rajesh (1/17/2016)

    Thanks a lot 🙂

    See my post above. Unless the guarantees that I stated above are enforced by constraints and then the a_m column is brought into play as...

    --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 21, 2016 at 6:49 pm

    #1853682

  • RE: Flag Values Based on Columns

    Hugo Kornelis (1/21/2016)

    Hey, here's another idea.

    Instead of bashing people who at least attempted to help the OP, why don't you chime in with your solution to the problem? For me,...

    --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 21, 2016 at 6:19 pm

    #1853681

  • RE: Help with an insert script

    Hugo Kornelis (1/20/2016)

    @dandrews: For future reference, what J Livingstone posted is a good repro script - CREATE TABLE and INSERT statements that people can simply copy/paste into SSMS and 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)

    January 21, 2016 at 5:37 pm

    #1853678

  • RE: How to pass parameter values to SQL query

    boettger.andreas (1/21/2016)

    Thanks. I've got it now with iTVF and CROSS APPLY

    Great. Can we see your code, please? A whole lot of people end up writing mTVFs instead of...

    --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 21, 2016 at 4:32 pm

    #1853676

  • RE: How to figure out whether data is selected from dirty pages?

    Hugo Kornelis (1/21/2016)

    I don't think that's possible.

    Also, even if you know what data is from dirty pages, you still do not have the full picture. Using read uncommitted can also...

    --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 21, 2016 at 4:01 pm

    #1853675

  • RE: Tree stucture

    I'm still interested in why this needs to be done, especially in T-SQL but it would appear the OP has flown the coop.

    --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 20, 2016 at 10:10 pm

    #1853357

  • RE: What is recursion?

    To me (programming wise), recursion is nothing more than a loop and has all of the same problems as a loop except there's no explicit loop making it 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)

    January 20, 2016 at 6:53 am

    #1853120

  • RE: Security Convenience

    Steve Jones - SSC Editor (1/19/2016)

    Jeff Moden (1/15/2016)

    Heh... the title of this article should be titled "Security vs Convenience" because the current title is actually a bit of an oxymoron.

    What...

    --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 20, 2016 at 6:37 am

    #1853114

  • RE: Having fun with PARSENAME (SQL Spackle)

    robert.sterbal 56890 (1/19/2016)

    The spackle articles would do well on a wiki.

    You know, that's a great idea. Steve Jones was talking about "exercises" for folks and that would fit 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 20, 2016 at 6:23 am

    #1853109

  • RE: Are the posted questions getting worse?

    jasona.work (1/19/2016)

    Paintball is getting more and more complicated...

    I wonder if it'll work with Express or if it needs Enterprise?

    I've been outlawed from paint ball forever... I threatened to build 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)

    January 19, 2016 at 5:45 pm

    #1853004

  • RE: The DBA Tax

    natewest (1/19/2016)

    I must admit when I heard "The DBA Tax" the first thing that popped into my head was "Buying Pizza for the DBA team so that they execute my...

    --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 19, 2016 at 5:42 pm

    #1853002

  • RE: what will happen?

    Eirikur Eiriksson (1/19/2016)

    Jeff Moden (1/19/2016)

    Rodan (1/19/2016)

    So if Trump is elected in the US – do you think we have to worry about him putting up fences around our foreign keys?...

    --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 19, 2016 at 5:37 pm

    #1853001

  • RE: Checking the bitwise value of an integer

    Jacob Wilkins (1/19/2016)

    Eirikur Eiriksson (1/19/2016)

    aaron.reese (1/19/2016)

    @jacob and @jeff

    SSRS is not my natural home 😀 so I was not aware that IIF(x AND y) is a bitwise operation. Maybe 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 19, 2016 at 5:17 pm

    #1852997

  • RE: what will happen?

    Rodan (1/19/2016)

    So if Trump is elected in the US – do you think we have to worry about him putting up fences around our foreign keys? :w00t:

    Heh... every time 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 19, 2016 at 3:06 pm

    #1852966

  • RE: Partition Table by Year

    Welsh Corgi (1/19/2016)

    EXEC sp_SpaceUsed tblCall

    name rows reserved ...

    --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 19, 2016 at 11:54 am

    #1852896

Viewing 15 posts - 18,541 through 18,555 (of 59,072 total)