Forum Replies Created

Viewing 15 posts - 43,486 through 43,500 (of 59,097 total)

  • RE: Differences between Unicode Text and ASCII text file

    RBarryYoung (6/10/2009)

    What you should be able to see however is that the Unicode .sql file is about twice the size of the Ascii one.

    Any idea if SQL Server supports UTF-8?

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

    June 10, 2009 at 9:16 pm

    #1007762

  • RE: Week numbers and week start dates

    balars_2000 (6/10/2009)

    thanks jeff.

    You bet. Thanks for the feedback. So, are you all set or do you have a remaining question?

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

    June 10, 2009 at 8:39 pm

    #1007755

  • RE: Differences between Unicode Text and ASCII text file

    It's what you can't see that makes the difference... the following is a very good article on the subject...

    http://www.joelonsoftware.com/articles/Unicode.html

    As a side bar, it took me about 2 minutes 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)

    June 10, 2009 at 8:27 pm

    #1007753

  • RE: Updating diff columns & multiple rows of same table

    {insert jeaopardy them song here} Heh... I'll just bet someone talked him into a cursor solution.

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

    June 10, 2009 at 8:00 pm

    #1007747

  • RE: Using sp_executesql to create dynamic sql

    Using QUOTENAME will pretty much put the kabosh on SQL Injection. But, I agree... if it's not used in a public facing environment, there's not much need for 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)

    June 10, 2009 at 7:57 pm

    #1007746

  • RE: Clustered Primary key index on INT column or on a date column

    Lynn Pettis (6/10/2009)

    If your date queries are range based, then the clustered index on the date column may be worthwhile. Remember, the clustered index is the order in which...

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

    June 10, 2009 at 7:51 pm

    #1007744

  • RE: Are the posted questions getting worse?

    lmu92 (6/10/2009)

    It's not that hard to generate sample data - but it's time consuming.

    It's a lot less time consuming than putting it into an excel spreadsheet, attaching the file, and...

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

    June 10, 2009 at 7:11 pm

    #1007738

  • RE: Mining for Quitters

    GSquared (6/10/2009)

    BUT, in a company with thousands of employees, can top management, or even upper middle management, actually get to personally know every employee?

    Absolutely agreed. I didn't say they...

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

    June 10, 2009 at 6:36 pm

    #1007730

  • RE: Mining for Quitters

    GSquared (6/10/2009)

    So, in other words, no human anywhere should use any tool for anything, because it will cause the loss of responsibility and "the human touch".

    I don't believe anyone even...

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

    June 10, 2009 at 6:15 pm

    #1007724

  • RE: Mining for Quitters

    Mad Hacker (6/10/2009)

    Although I was initially receptive to this idea, I've about decided that the benefit(s) may not outweigh the costs. Although it sounds like a great idea 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)

    June 10, 2009 at 11:54 am

    #1007600

  • RE: Random problems

    drogers (6/10/2009)

    Uh, why would you "not agree with the idea that RAND() doesn't work like NEWID() in T-SQL." Do you find the discrepancy "unexpected?" 😀

    Heh... Only the first time...

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

    June 10, 2009 at 11:09 am

    #1007570

  • RE: O(n) , O(n log n), O(n^2)

    RBarryYoung (6/9/2009)

    Jeff Moden (6/9/2009)

    O(wtf2) 😉

    Heh. Hey, I'm not the one who asked the question, I'm just trying to answer them.

    Oh no... sorry, Barry. Wasn't directed at anyone 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)

    June 10, 2009 at 5:52 am

    #1007287

  • RE: Random problems

    Mike C (6/9/2009)

    Jeff Moden (6/9/2009)

    Mike C (6/9/2009)

    Another minor quibble - each instance of RAND() is invoked once per query.

    SELECT RAND(), RAND()

    Generates two different random numbers because RAND() is actually called...

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

    June 9, 2009 at 10:45 pm

    #1007187

  • RE: Mining for Quitters

    Steve Jones - Editor (6/9/2009)

    I agree with you, Jeff, but who do you talk to? I've known plenty of people that were thinking of leaving, and wouldn't want to let...

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

    June 9, 2009 at 10:40 pm

    #1007185

  • RE: Week numbers and week start dates

    balars_2000 (6/9/2009)

    I would display 0's to indicate there was no data during that particular week.

    --Ta

    Then you need a complete list of dates to join against for any given year...

    [font="Courier New"]DECLARE @FirstDate DATETIME

     SELECT @FirstDate = '20090104'

     SELECT v.Number AS Week,

            DATEADD(wk, v.Number   ,@FirstDate) AS StartDate,

            DATEADD(wk, v.Number+1 ,@FirstDate) AS NextDate

       FROM Master.dbo.spt_Values v

      WHERE Type = 'P' 

        AND Number BETWEEN 0 AND 51[/font]

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

    June 9, 2009 at 10:34 pm

    #1007184

Viewing 15 posts - 43,486 through 43,500 (of 59,097 total)