Forum Replies Created

Viewing 15 posts - 42,571 through 42,585 (of 59,067 total)

  • RE: How to join Candidate and Qualification tables

    pandeharsh (8/2/2009)

    Hi,

    I think I hv posted my problem ok like providing,structure of tables.

    only thing is that i didn't populated my tables.

    Then, as you have stated, "You have half understtod...

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

    August 2, 2009 at 4:32 pm

    #1033482

  • RE: Disable and enabling index frequently

    manohar (8/2/2009)

    Hi all,

    I have a table in which records frequently gets inserted. Around 5000 records per minute.

    I am selecting data from that table once or twice per minute

    Because of huge...

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

    August 2, 2009 at 4:11 pm

    #1033480

  • RE: Shrinking Database

    trayalacheruvu (7/28/2009)

    Hi,

    i have around 500 tables in my database with size of 20 GB. Now i am planing to remove 200 tables from the database. after deleting the database still...

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

    August 2, 2009 at 4:05 pm

    #1033478

  • RE: Are the posted questions getting worse?

    RBarryYoung (8/2/2009)

    Oh Jeff, ... You might want to take this one ... 😀

    By the way, Barry... thank you for the very high compliment about SSC and the Tally table....

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

    August 2, 2009 at 3:38 pm

    #1033477

  • RE: Be a Craftsman

    I'm just going to skip over the words "unionize IT workers". It may be right for some but not for me, thank you.

    And, yeah... I've pretty much always chosen...

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

    August 2, 2009 at 3:16 pm

    #1033475

  • RE: Migrating Foxpro database programs to SQL 2005

    novice_coder (8/2/2009)

    Hello Allister,

    Thanks for the help. Your code shows how to think column wise rather than going row by row. I am getting a hang of it now. And you...

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

    August 2, 2009 at 3:09 pm

    #1033474

  • RE: Are the posted questions getting worse?

    RBarryYoung (8/2/2009)

    Oh Jeff, ... You might want to take this one ... 😀

    For some reason, that thread hasn't been notifying me of new posts via email. I've responded...

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

    August 2, 2009 at 3:04 pm

    #1033473

  • RE: Be a Craftsman

    David Korb (8/2/2009)

    I spent about 40 minutes crafting a reply, but when I hit "Preview" received a "The session identity provided has expired or could not be found." message. 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)

    August 2, 2009 at 11:44 am

    #1033458

  • RE: Migrating Foxpro database programs to SQL 2005

    novice_coder (8/1/2009)

    Hello Jeff,

    You are the man. Everything is going in SPs and I am scheduling the scripts calling these SPs.

    Thanks for the help.

    On RBAR: I guess 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)

    August 2, 2009 at 11:03 am

    #1033454

  • RE: Date conversion

    Heh... everybody is happy... 'cept me. 😛 No one answered my question. Here it is again...

    Does SSRS have something in it to take an SQL DateTime and format...

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

    August 2, 2009 at 10:58 am

    #1033452

  • RE: Store Proc Error

    Actually, this is the way I write code at work... it makes debugging much, much easier...

    ALTER PROCEDURE TraceReport

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

    August 2, 2009 at 10:52 am

    #1033451

  • RE: Store Proc Error

    Ah crud... sorry Tara... I forgot that EXEC will only take constants and variables as operands. It won't take functions. For example...

    EXEC('SELECT ' + SQRT(4))

    ... fails just like...

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

    August 2, 2009 at 10:49 am

    #1033450

  • RE: Be a Craftsman

    David Korb (8/1/2009)

    ...because you may end up maintaining CLR routines on SQL Server.

    Heh... just having a little fun here... if you know T-SQL well enough, there isn't a need 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)

    August 2, 2009 at 10:03 am

    #1033445

  • RE: Purchase of SQL Server 2005 Developer Edition

    freens77 (8/1/2009)

    Jeff, thanks for your reply. I had believed and hoped that was the case. Thanks for eliminating that concern for me. 🙂

    Cheers.

    No problem and Lowell is correct......

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

    August 1, 2009 at 6:18 pm

    #1033413

  • RE: Be a Craftsman

    So long as Microsoft isn't responsible for the certs. I see no reason to know how to write in C# if I'm going to be a DBA or Database...

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

    August 1, 2009 at 6:12 pm

    #1033411

Viewing 15 posts - 42,571 through 42,585 (of 59,067 total)