Forum Replies Created

Viewing 15 posts - 40,111 through 40,125 (of 59,072 total)

  • RE: Need help to built SQL statement

    Wow! Nicely done, miss.delinda. There are people on this site who have >500 posts that still haven't figured out how to get the best help and you nailed...

    --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 23, 2010 at 10:45 pm

    #1107879

  • RE: Avoiding Log full Error

    mahesh.vsp (1/23/2010)

    I feel, irrrespective of recovery model , until the txn is completed, the LDF file keeps increasing and once completed only then it can be re-used by other transaction.

    That's...

    --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 23, 2010 at 10:40 pm

    #1107878

  • RE: Query optimization

    I believe I'd use UNION ALL for this. UNION essentially does a distinct which is probably not necessary here.

    --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 23, 2010 at 10:31 pm

    #1107877

  • RE: Tally Table

    RBarryYoung (1/23/2010)

    Jeff Moden (1/7/2010)

    ... there's likely a set based solution that will keep all forms of RBAR at bay here.

    Heh. Well, all but one ... 😀

    Where did you get...

    --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 23, 2010 at 10:24 pm

    #1107876

  • RE: Normalization

    Jeff Moden (1/23/2010)

    So, when YOU create an address table, do you have a "second address" line or do you normalize it? Enquiring minds want to know. 🙂

    I'd still 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)

    January 23, 2010 at 10:20 pm

    #1107875

  • RE: extract days,hour,min,sec

    I'd say you've made it hard on yourself...

    SELECT STR(DATEDIFF(dd,0,GETDATE()-@Sql_Start_Time),5) + ' Days, '

    + DATENAME(hh,GETDATE()-@Sql_Start_Time) + ' Hours, '

    ...

    --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 23, 2010 at 10:14 pm

    #1107873

  • RE: Where are you?

    Heh... you're not lion... guess you'll have to grin and bear 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)

    January 23, 2010 at 1:02 pm

    #1107809

  • RE: SQL tables

    As a side bar... That's one of the things I miss about SQL Server 2000 and Query Analyzer where you could just press {f4} for such a thing.

    --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 23, 2010 at 12:49 pm

    #1107805

  • RE: SQL Scripts - How to run and get results

    I've never done it so don't know for sure but rumor has it that C2 auditing is rather fierce in the amount of data it captures. I'm not 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 23, 2010 at 12:47 pm

    #1107804

  • RE: Normalization

    So, when YOU create an address table, do you have a "second address" line or do you normalize it? Enquiring minds want to know. 🙂

    --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 23, 2010 at 12:34 pm

    #1107798

  • RE: How Do You Handle the Stress of Being a DBA?

    Heh... lately for me, a better question would be "How do you deal with the stress of other DBA's?" 😉

    --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 23, 2010 at 12:04 pm

    #1107789

  • RE: Display date in DD/MM/YYYY HH:MI:SS:MMMAM

    This will do it...

    SELECT CONVERT(CHAR(10),GETDATE(),103) + ' ' + RIGHT(CONVERT(CHAR(26),GETDATE(),109),14)

    --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 23, 2010 at 11:57 am

    #1107788

  • RE: Tempdb is full

    CirquedeSQLeil (1/23/2010)

    There is a poorly written runaway sql statement causing heavy tempdb usage.

    Concur. In fact, I've found that to be the norm rather than the exception.

    --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 23, 2010 at 11:35 am

    #1107785

  • RE: Where are you?

    Detroit. We have Lions here, too, but they have no teeth. 😉

    --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 23, 2010 at 11:30 am

    #1107782

  • RE: Finding duplicate row values

    malleswarareddy_m (1/23/2010)

    ok i did not hijack others thraed

    but this is my urgent requirement report in company.

    so i posted here understanding me

    ok sorry.

    As a side bar, any time something 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 23, 2010 at 11:23 am

    #1107781

Viewing 15 posts - 40,111 through 40,125 (of 59,072 total)