Forum Replies Created

Viewing 15 posts - 27,961 through 27,975 (of 59,101 total)

  • RE: Add Many-to-Many all at once

    JimS-Indy (12/5/2012)

    This is a list of Part numbers (Items) linked with their (zero or more) Sources of supply (vendors, etc.) An item could have half a dozen sources, though typically...

    --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 5, 2012 at 10:03 pm

    #1566004

  • RE: Third-Party TDE?

    My google search qucikly turned up 3 possibilities.... Vantive, Vormetric, and SafeNet. Didn't do a deep dive on any of those, though.

    --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 5, 2012 at 10:00 pm

    #1566003

  • RE: Solve Problems Using Recursive CTE

    bj_shenglong (12/5/2012)

    There is a particular problem, let's' say, we just want to find out who sold more then 2 each month in at least two consecutive months and when.

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

    December 5, 2012 at 9:22 pm

    #1566000

  • RE: Simple SQL Question...

    tooba111 (12/5/2012)

    Hi Guys,

    Simple question but don't know the answer, In my database i have 99 table that don't have any rows. My question is, it would be good idea

    if...

    --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 5, 2012 at 8:45 pm

    #1565995

  • RE: Simple SQL Question...

    CELKO (12/5/2012)

    In my database I have 99 table that don't have any rows. My question is, it would be good idea if I delete those tables or leave them...

    --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 5, 2012 at 8:30 pm

    #1565993

  • RE: how to explain the correlated subquery

    viveksvkola (12/5/2012)

    Hi All,

    I want to know how to explain the correlated subquey like "SELECT * FROM CUSTOMER A WHERE 1=(SELECT COUNT(DISTINCT SAL) FROM CUSTOMER B WHERE A.SAL<=B.SAL)".

    Pls any one can...

    --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 5, 2012 at 8:23 pm

    #1565990

  • RE: Exercises in t-SQL

    ScottPletcher (12/5/2012)

    Jeff Moden (12/4/2012)

    ScottPletcher (12/4/2012)

    It would take far longer than 2 minutes to give the full background you wanted.

    This for a simple, introductory interview q, when I often had two...

    --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 5, 2012 at 7:51 pm

    #1565987

  • RE: Best way to sync two databases?

    Evil Kraig F (12/5/2012)

    If possible, can you offer a lot more detail into the data status on the two databases and future intent?

    If you're looking at a complete overwrite 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)

    December 5, 2012 at 4:58 pm

    #1565968

  • RE: Looking for some advice on a career problem...

    If you're in a company where only two of you (as you said) know SQL Server and you want to stay with SQL Server, perhaps it's time to have 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)

    December 5, 2012 at 4:49 pm

    #1565967

  • RE: Solve Problems Using Recursive CTE

    bj_shenglong (12/5/2012)

    But I assume this way could be faster...

    That's how rumors of performance get started. 🙂

    Write code to build a million row test table and test your hypothesis. No...

    --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 5, 2012 at 4:39 pm

    #1565965

  • RE: Add Many-to-Many all at once

    JimS-Indy (12/5/2012)

    @jeff,

    I had a similar idea, basically using the identity column from the input table, I can insert that value into a spare column in each of 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)

    December 5, 2012 at 4:21 pm

    #1565963

  • RE: xp_cmdshell works and then doesn't work

    Could it be that the files are moved out of the directory, at some point, and that the DIR is reporting correctly?

    --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 5, 2012 at 10:25 am

    #1565851

  • RE: Random index corruption

    reguitti (12/5/2012)

    The thing which is giving me some perplexity is that before the upgrade to a new version of the software which is using this DB...

    Not perplexing at all. ...

    --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 5, 2012 at 10:17 am

    #1565848

  • RE: trigger when a specific column gets updated

    Minnu (12/5/2012)

    Hi Team,

    It's my first time to use triggers so....?

    So... From SSMS, press the F1 key to get into Books Online. Then search for CREATE TRIGGER and start reading....

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

    #1565754

  • RE: Interview Questions

    komal145 (12/4/2012)

    Hi..I had an interview and had few questions:

    Can anyone please help me finding out answers for the below questions?

    1) Design table to track phone?

    2) how to troubleshoot high volume...

    --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 5, 2012 at 7:20 am

    #1565748

Viewing 15 posts - 27,961 through 27,975 (of 59,101 total)