Forum Replies Created

Viewing 15 posts - 4,231 through 4,245 (of 59,069 total)

  • Reply To: One to many SQL Server books

    Thanks for taking the time to write this article, Kathi.

    What's even worse than what you mention is that the quality of the "official" documentation has totally tanked as is frequently...

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

    December 11, 2021 at 9:23 pm

    #3962743

  • Reply To: permissions

    ScottPletcher wrote:

    Jeff Moden wrote:

    ScottPletcher wrote:

    Jeff Moden wrote:

    frederico_fonseca wrote:

    why do other uses need to see who can login on a server? that is on its own a security risk and should not be...

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

    December 10, 2021 at 10:06 pm

    #3962536

  • Reply To: Issue with Schema Removal from Table or view

    mcfarlandparkway wrote:

    I have another question, I have data with space before square brackets and after sqaure brackets when i run below example 1 statement returning NULL.  But in example 2...

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

    December 10, 2021 at 9:48 pm

    #3962530

  • Reply To: permissions

    ScottPletcher wrote:

    Jeff Moden wrote:

    frederico_fonseca wrote:

    why do other uses need to see who can login on a server? that is on its own a security risk and should not be exposed by...

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

    December 10, 2021 at 6:22 pm

    #3962482

  • Reply To: Issue with Schema Removal from Table or view

    Scott's method is the method I'd use to extract the object name.

    I do concern myself what the source of the name is an how it will be used later 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)

    December 10, 2021 at 5:23 pm

    #3962467

  • Reply To: permissions

    frederico_fonseca wrote:

    why do other uses need to see who can login on a server? that is on its own a security risk and should not be exposed by default.

    If it...

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

    December 10, 2021 at 5:16 pm

    #3962465

  • Reply To: Group based on start and end dates

    Sam Vanga wrote:

    Thanks for your hint! I used a calendar table and DENSE_RANK() as shown in the article to solve my problem. I appreciate your help very much.

    To help others that...

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

    December 10, 2021 at 5:14 pm

    #3962464

  • Reply To: Select TOP N returning N+ rows with OpenQuery to Snowflake

    Total SWAG on my part but NOT using parentheses for the "N" number is only allowed for SELECTs and they did that only for backward compatibility.  The correct syntax 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)

    December 10, 2021 at 3:10 pm

    #3962413

  • Reply To: how much memory that we need for SQL

    wrote:

    Thanks for sharing, I am very impressed with your post.

    Smell that?  {sniff}... smells like  a prelude to SPAM.

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

    December 10, 2021 at 2:45 pm

    #3962406

  • Reply To: concat + isnull

    If you missed that about CONCAT_WS, you may have missed another fantastic enhancement they came out with 2017.  The TRIM function.  Most people give it the "yawn" because they think...

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

    December 8, 2021 at 9:17 pm

    #3961803

  • Reply To: Creating a unique value for a certain period & staff

    Thanks for your feedback on what you've done.  Can you provide expanded test data to demonstrate what you've done?

    And, you've not avoided any joins like you said you wanted 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)

    December 8, 2021 at 8:31 pm

    #3961794

  • Reply To: Row limit for Updates before transaction log fills up

    Lord Slaagh wrote:

    Hello SSC,

    I hope everyone is staying safe and healthy.

    I am using SQL 2017 and I have over 17 million rows that I have to UPDATE. Obviously I have 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)

    December 8, 2021 at 8:26 pm

    #3961793

  • Reply To: Worse Before Better

    wabmaster wrote:

    I wound up in a highly similar position implementing 'immediate fixes' and never able to get to long-term solutions to stop all the 'immediate fixes.'  It forced me into...

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

    December 8, 2021 at 8:15 pm

    #3961792

  • Reply To: Worse Before Better

    wabmaster wrote:

    I wound up in a highly similar position implementing 'immediate fixes' and never able to get to long-term solutions to stop all the 'immediate fixes.'  It forced me into...

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

    December 8, 2021 at 8:06 pm

    #3961791

    • Viewing 15 posts - 4,231 through 4,245 (of 59,069 total)