Forum Replies Created

Viewing 15 posts - 50,536 through 50,550 (of 59,102 total)

  • RE: Tally Table

    If ya wanna have some fun, make as much performance improvement as you can to the first query found at the following URL... result must be functionally identical to 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)

    May 15, 2008 at 11:02 pm

    #816255

  • RE: nvarchar vs varchar

    GilaMonster (5/13/2008)

    Jeff Moden (5/13/2008)

    Heh... can't wait for the mess folks are gonna make in 2k8 with the separate DATE and TIME datatypes...

    Agreed. There are legit cases to store just one...

    --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 15, 2008 at 8:24 pm

    #816229

  • RE: pivot

    Welcome aboard, Mark,

    Hey... since you're a "newbie", take a look at the URL in my signature line. It'll help you and folks like me a lot in the future.

    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)

    May 15, 2008 at 6:50 pm

    #816219

  • RE: Calling CLR procedures from user defined functions

    I have no idea why MS does certain things. 😛

    Just curious, what does the CLR do?

    --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 15, 2008 at 6:25 pm

    #816218

  • RE: The CLR

    Will DOugherty (5/15/2008)

    I know this is a forum by and for SQL Server bigots but there is also the possibility that those of us who are strong in the .Net...

    --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 15, 2008 at 5:59 pm

    #816214

  • RE: SQL Year and Week numbers

    Lester Policarpio (5/15/2008)

    Why does some members tend to double post? :hehe:

    I can't actually blame them... they look at all the different forums and think they stand a better chance of...

    --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 15, 2008 at 5:43 pm

    #816212

  • RE: getdate() accuracy

    SQLServerLifer (5/15/2008)

    The GETDATE() function returns a DATETIME type. Therefore it will inherit the same rounding limitation.

    DAB

    Cool! Show us the code that proves it because non of the rest of...

    --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 15, 2008 at 5:36 pm

    #816210

  • RE: About trigger

    Yes... it's possible... give it a whirl.

    --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 15, 2008 at 4:22 pm

    #816204

  • RE: High CPU utilization and query is slow

    I'd recommend you post the code... I've not seen Order By in an execution plan with so many columns ever before.

    --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 15, 2008 at 4:16 pm

    #816201

  • RE: Bulk Insert to a temorary table

    When you try to Bulk Insert into a Temp table, the use must have privs to write to C:\Temp on the server because some working files are created there.

    --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 15, 2008 at 4:09 pm

    #816197

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Looks interesting... can't download the code, though, because I'm not a member and they want too much info for my liking.

    --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 15, 2008 at 4:07 pm

    #816196

  • RE: Performance Tuning meeting

    fosco (5/15/2008)

    Good Morning,

    I need some advice on what to bring up at a meeting with some developers concerning the performance issues they have been experiencing, they said its 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)

    May 15, 2008 at 3:49 pm

    #816187

  • RE: getdate() accuracy

    That's good info... but like JackO said, that's for DATETIME precision... not GETDATE precision. We're trying to figure out why a high speed loop seems to indicate that GETDATE...

    --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 15, 2008 at 8:07 am

    #815900

  • RE: Tally Table

    karthikeyan (5/15/2008)

    Jeff,

    vow...Plenty of uses...

    Could you please give me examples for all those uses ? I am eagerly waiting for your reply.

    Sure... do a search on "Tally Table" or "Number 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)

    May 15, 2008 at 7:28 am

    #815859

  • RE: Tally Table

    Take a look at the following URL for additional uses such as

    Encoding/Decoding a string

    Removing text between delimiters such as in HTML

    Doing a "moving" average

    Finding/Counting Days of the Week

    Finding/Counting Weekdays...

    --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 15, 2008 at 7:24 am

    #815855

Viewing 15 posts - 50,536 through 50,550 (of 59,102 total)