Forum Replies Created

Viewing 15 posts - 39,721 through 39,735 (of 59,098 total)

  • RE: FizzBuzz

    Heh... I just Googled "FIZZBUZZ SOLUTIONS SQL"... I'm amazed and surprised that some of those folks had the nerve to publish some of the solutions they have. Maybe it'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)

    February 21, 2010 at 10:21 pm

    #1122694

  • Reply To: FizzBuzz

    For the kind of developers I like to hire, speed, performance, and quality all just happen. It doesn't take any longer to write quality high speed code than it does...

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

    February 21, 2010 at 9:01 pm

    #1122663

  • RE: Unique Key on Text datatype

    Speaking of killing things... I can't believe that anyone would put a default on a password column unless it's meant to daze and confuse. 😉

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

    February 21, 2010 at 8:23 pm

    #1122659

  • RE: Performance Tuning Woe's

    Chris Kitchen (2/20/2010)

    I've inherited this code and I'm told it that a re-write just isn't possible at the present time.

    p.s. I honestly feel for you. You're told 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)

    February 21, 2010 at 8:21 pm

    #1122658

  • RE: Performance Tuning Woe's

    You mentioned that you had a fair number of deadlocks and the code causing those deadlocks is also responsible for a fair bit of your performance problem. First, when...

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

    February 21, 2010 at 8:09 pm

    #1122654

  • RE: High plan count on query without literal values

    chris.nilsson (2/19/2010)

    SQL 2008

    In Activity Monitor's Recent Expensive Queries, this query shows up with a Plan Count value showing around 130:

    SELECT TOP 1 sMeasureNum, sMeasureDesc, DenomDesc, sQuestion1, sQuestion2, sQuestion3,

    sQuestion4, sQuestion5...

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

    February 21, 2010 at 7:55 pm

    #1122650

  • RE: nullable foreign keys for all primary keys

    smita.patil (2/21/2010)

    I have query like:-

    Transactions.StartDate BETWEEN AmountSettings.StartDate AND AmountSettings.EndDate

    AND

    AmountSettings.LocationID = Transactions.LocationID OR AmountSettings.LocationID is NULL

    AND

    AmountSettings.BandID =Transactions.BandID OR AmountSettings.BandID IS NULL

    ANd so on for other foreign keys....

    but this query is not...

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

    February 21, 2010 at 7:49 pm

    #1122648

  • RE: Help- Very Complex SQL query

    WayneS (2/21/2010)

    Jeff Moden (2/21/2010)

    [Please see the article others are pointing to and if you're not going to use the method correctly, then do use it at all.

    Jeff, don't you mean...

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

    February 21, 2010 at 7:41 pm

    #1122647

  • RE: Sequence? Increment?

    You have a nice table somewhere to experiment with. We don't. Please see the article at the first link in my signature below to help us help 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)

    February 21, 2010 at 7:32 pm

    #1122645

  • RE: When Do You Deploy?

    "Downtime"? Heh... I've gotta Google that and find out what it means. 😉

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

    February 21, 2010 at 7:23 pm

    #1122643

  • RE: Stored Procedure Parameters

    I personally don't like the extra overhead the XML puts on the "pipe" or the SQL Server during XML shredding. Also, since this is an SQL Server 2005 forum,...

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

    February 21, 2010 at 7:16 pm

    #1122642

  • RE: Help- Very Complex SQL query

    Sash Mav (2/19/2010)

    Ohh buddy - that worked like a charm. I am such a fool not to think from basics.

    Arun certainly has the correct idea but, being the author 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)

    February 21, 2010 at 7:00 pm

    #1122638

  • RE: ALTER a HUGE TABLE

    Vinay,

    I've not read all of the posts on this thread so let me ask... can the system be down while you do this or not? If so, for how long?

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

    February 21, 2010 at 6:19 pm

    #1122629

  • RE: Eliminating Cursors

    Very cool set of links, Barry. Great blog site on your part, as well! Other than the awesome content (haven't explored it all, yet, of course) is that...

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

    February 21, 2010 at 10:06 am

    #1122514

  • RE: Temporal Query Problem

    My bad... I didn't explain well enough. You need to find the OPEN for each CLOSED in order to pick up on the "reopens".

    So far as 45 and 51...

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

    February 20, 2010 at 5:58 pm

    #1122402

Viewing 15 posts - 39,721 through 39,735 (of 59,098 total)