Forum Replies Created

Viewing 15 posts - 38,641 through 38,655 (of 59,072 total)

  • RE: Index on Date Time Column Not Getting Used

    I created my own test table instead of waiting... here's the code (which you should have posted to begin with, thanks 😉 )...

    DROP TABLE #MyHead;

    GO

    WITH

    ...

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

    May 1, 2010 at 7:54 pm

    #1160943

  • RE: Index on Date Time Column Not Getting Used

    uppal.kunal (5/1/2010)

    I have started working on indexes lately and was studying indepth about them in Sql Server.

    I created a a nonclustered index on a table Which had just 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)

    May 1, 2010 at 7:23 pm

    #1160941

  • RE: Regular Service

    Heh... my vote would be... do it all right the first time. 😛 Yeah, I know... not practical. But I can wish.

    While I'm here... have any of 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)

    May 1, 2010 at 7:21 pm

    #1160940

  • RE: Quick question about len

    Absolutely my bad. Not sure why i was thinking that LEN would be affected by those. What I was thinking of was how much space was wasted 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)

    May 1, 2010 at 5:35 pm

    #1160938

  • RE: convert string to ascii values

    LondonNick (4/30/2010)

    A very similar script is in BOL if you look up CHAR.

    Agreed... and it shouldn't be used either. 😉

    For those that haven't seen it, please see the following 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)

    May 1, 2010 at 5:07 pm

    #1160936

  • RE: convert string to ascii values

    Jon McGhee (4/30/2010)

    Cool. I did not know that, but I see it now. Usually when I look for code examples I don't search BOL, I search this site....

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

    May 1, 2010 at 5:03 pm

    #1160935

  • RE: Median

    keywestfl9 (5/1/2010)

    yes it helped to finish my task. thank you all for the help

    They want to do for another report in access the same thing,i will try and post 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)

    May 1, 2010 at 4:48 pm

    #1160934

  • RE: MCJ - The Missing Link

    CirquedeSQLeil (4/29/2010)

    Lynn Pettis (4/29/2010)

    CirquedeSQLeil (4/29/2010)

    Steve Jones - Editor (4/29/2010)

    I went back and looked at the wording in Jeff's draft. The issue there is that many of us borrow code 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)

    May 1, 2010 at 10:00 am

    #1160909

  • RE: MCJ - The Missing Link

    Steve Jones - Editor (4/29/2010)

    I went back and looked at the wording in Jeff's draft. The issue there is that many of us borrow code for others and use 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)

    May 1, 2010 at 9:06 am

    #1160904

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (4/30/2010)

    Lynn,

    I think it was OK. From a technical standpoint, it makes sense. The issue seems that some people don't understand log chaining, so things read funny...

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

    May 1, 2010 at 8:52 am

    #1160901

  • RE: Median

    @keywestfl9,

    So... are you all set now or do you have other questions about MEDIANs?

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

    May 1, 2010 at 8:48 am

    #1160900

  • RE: Cast Float to Char with Natural Rounding

    Paul White NZ (5/1/2010)

    Jeff Moden (4/30/2010)

    Using the great start that Paul provided, the following will also drop the decimal point if a whole number is realized...

    Great stuff! Thanks so...

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

    May 1, 2010 at 8:43 am

    #1160899

  • RE: Table and design advice

    Digs (5/1/2010)

    Thanks Jeff, Speed much improved !!

    :-):-D:-):-D

    Thanks for the feedback, Digs. 🙂

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

    May 1, 2010 at 8:39 am

    #1160898

  • RE: Tempdb GROWS

    2cams (4/30/2010)

    Hi Grant, Solarwinds is a server performance monitoring application which is 3rd party. We logged a call with them enquiring about the tempdb issues we haing.

    We will monitor 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)

    April 30, 2010 at 11:33 pm

    #1160867

  • RE: Trying to use variables in a view.

    itskumar2004 (4/26/2010)

    Hi,

    I want to use a variable in a view.so i created a stored procedure and in that i have created a view .but, when i used the variable ina...

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

    April 30, 2010 at 11:27 pm

    #1160865

Viewing 15 posts - 38,641 through 38,655 (of 59,072 total)