Forum Replies Created

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

  • 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

  • RE: Tally Table

    Find bad characters in a string

    Remove Digits from Strings

    Remove Alpha from "numbers"

    Change to Title Case

    Histogram of characters in a column

    Generate test data (not just dates)

    Find gaps in serial numbers or...

    --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 14, 2008 at 11:27 pm

    #815638

  • RE: getdate() accuracy

    The following shows the accuracy you're talking about...

    SELECT 1,CAST('2000-01-01 23:59:59.990' AS DATETIME) UNION ALL

    SELECT 2,CAST('2000-01-01 23:59:59.991' AS DATETIME) UNION ALL

    SELECT 3,CAST('2000-01-01 23:59:59.992' AS DATETIME) UNION ALL

    SELECT...

    --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 14, 2008 at 10:48 pm

    #815623

  • RE: getdate() accuracy

    The CPU does other things... it's not dedicated to running your code.

    --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 14, 2008 at 10:41 pm

    #815621

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