Forum Replies Created

Viewing 15 posts - 18,676 through 18,690 (of 59,072 total)

  • RE: Page split with Clustered index

    imct1960 (1/8/2016)

    Thanks Jeff, I was reading the article today and was hoping for a conclusion.

    It does annoy me, the accusations of thread resurrection. If the new info. is...

    --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 8, 2016 at 5:54 am

    #1850478

  • RE: Creating Seperate Schema

    SQL!$@w$0ME (1/7/2016)

    Why should I create separate schemas?

    Depending on what you need to protect from group to group, the use of schemas can make privs a bit easier to assign...

    --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 8, 2016 at 5:40 am

    #1850475

  • RE: the use of CTEs

    Jason A. Long (1/7/2016)

    Jeff Moden (1/7/2016)

    Can't argue that without an example. I'll have to check on some of the execution plans on my prod system. I'm pretty sure...

    --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 8, 2016 at 5:37 am

    #1850473

  • RE: the use of CTEs

    Hugo Kornelis (1/8/2016)

    Jeff Moden (1/7/2016)

    Alan.B (1/6/2016)

    You can't write a recursive CTE with using pre-CTE features.

    Technically correct because only an rCTE can be an rCTE but the rather well advertised...

    --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 8, 2016 at 5:31 am

    #1850471

  • RE: Crosstab query NOT using pivot

    Exactly. Thanks for the early morning cover, Graham.

    --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 8, 2016 at 5:12 am

    #1850466

  • RE: the use of CTEs

    erics44 (1/8/2016)

    ...and would that be considered daft use of a recursive CTE?

    Virtually any form of counting or other RBAR, even if it's for a low number of iterations. 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)

    January 8, 2016 at 5:08 am

    #1850464

  • RE: Send email from T-SQL

    Again, sorry for the delay. I'd lost track of this particular thread.

    The code I spoke of is below. Look for the word "TODO" for changes that you'll need...

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

    #1850410

  • RE: Send email from T-SQL

    Rich Mechaber (1/7/2016)

    Hi, Jeff, we're all still waiting for this super-duper magical emailing code you allege to have concocted!

    :rolleyes:

    Rich

    First, thanks for responding. I had delete a whole bunch 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 7, 2016 at 10:42 pm

    #1850408

  • RE: the use of CTEs

    Hugo Kornelis (1/6/2016)

    Oh, one more note. In between all the getting carried away with details and terminology and everyone being right and stuff, I forgot to add my two cents...

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

    #1850403

  • RE: the use of CTEs

    Alan.B (1/6/2016)

    You can't write a recursive CTE with using pre-CTE features.

    Technically correct because only an rCTE can be an rCTE but the rather well advertised rave in SQL Server...

    --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 7, 2016 at 9:39 pm

    #1850402

  • RE: the use of CTEs

    Jason A. Long (1/7/2016)

    Jeff Moden (1/7/2016)

    Jason A. Long (12/24/2015)

    Unless you're using recursion, a CTE can be rewritten as a derived table... Considering that derived tables (and CTEs) are processed before...

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

    #1850394

  • RE: the use of CTEs

    Sergiy (1/7/2016)

    Jeff Moden (1/7/2016)

    That being said, let's please avoid a "Banker's Rounding" discussion on this thread. Thanks guys.

    Too late, mate.

    Sorry. 😛

    BWAAA-HAAA!!!! Only 300 or 400 more posts 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 7, 2016 at 6:25 pm

    #1850393

  • RE: Hacking to Hide

    Amazing. I think these things are a bit crazy, whether they be shipboard or on airplanes, considering the technology that's been available for a relatively long time now. ...

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

    #1850391

  • RE: Crosstab query NOT using pivot

    Tallboy (1/7/2016)

    Hi Folks;

    Jeffs code ran brilliantly until changed my test data and added two appointment rows for the same client with same date and times data but with different StaffID's.

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

    #1850388

  • RE: Row_number partition by specific range of numbers start with int and ends with char

    lsalih (1/6/2016)

    Perfect, it worked like a charm! Now I have one last question to ask: The ultimate goal is after we group the data is to extract each subset 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 7, 2016 at 5:03 pm

    #1850387

Viewing 15 posts - 18,676 through 18,690 (of 59,072 total)