Forum Replies Created

Viewing 15 posts - 43,666 through 43,680 (of 59,063 total)

  • RE: NATURAL JOIN

    RBarryYoung (5/23/2009)

    Say what!!! You're quoting ANSI standards??? ...

    Alright buddy, Who are you and what have you done with Jeff!

    😀

    BWAA-HAAA!!! No, I haven't lost my tin hat,...

    --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 23, 2009 at 8:01 pm

    #999401

  • RE: NATURAL JOIN Syntax IN SQL Server 2005

    The author of that article didn't do his homework on joins. There is no Natural Join in SQL Server. And, if you research it a bit, if such...

    --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 23, 2009 at 7:41 pm

    #999399

  • RE: To write a query

    Florian Reischl (5/23/2009)

    Also very clean to use an tab-lock and an index hint to ensure the order!

    Just so long as no one thinks they can do that with a non-clustered...

    --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 23, 2009 at 7:31 pm

    #999398

  • RE: To write a query

    Very cool, Flo. We're getting all of the running total methods out in the open. Care to write a CLR for this bad boy?

    The INNER JOIN method, 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)

    May 23, 2009 at 7:18 pm

    #999396

  • RE: NATURAL JOIN

    Heh... curiously enough, Microsoft and Oracle have two different descriptions of what a "natural" join is.

    http://support.microsoft.com/kb/136699

    [font="Arial Black"]The Equi-Join and Natural Join[/font]

    Almost all joins, including all examples given so far, are...

    --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 23, 2009 at 6:40 pm

    #999389

  • RE: To write a query

    The inline code jumped from 41 seconds at 10,000 rows to 170 seconds for 20,000 rows. In other words, the amount of time increases by a factor of 4...

    --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 23, 2009 at 2:55 pm

    #999381

  • RE: To write a query

    Florian Reischl (5/23/2009)

    Good point Jeff. If there are more than four rows 😀 an inline query gets a bad performance.

    One question:

    Did you figure out if a cross join performs better...

    --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 23, 2009 at 2:35 pm

    #999378

  • RE: To write a query

    That's a "running total" problem. Inline queries are ok for only the smallest of collections. See the following for why...

    http://www.sqlservercentral.com/articles/T-SQL/61539/

    If you have more than small collections of data...

    --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 23, 2009 at 1:22 pm

    #999370

  • RE: Introduction to Bitmasking in SQL Server, Part 2

    First, this series of articles is good and I won't take anything away from the author on it. Well done.

    But, I agree with many of the others when 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 23, 2009 at 1:14 pm

    #999367

  • RE: Introduction to Bitmasking in SQL Server, Part 2

    Mitch Miller (5/21/2009)

    Sorry LP -- I just had a nice big explanation with examples, and this damn website took it and tossed it. Now I'm pissed. I can't...

    --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 23, 2009 at 12:53 pm

    #999366

  • RE: Query Elapsed Time

    Florian Reischl (5/23/2009)

    Jeff Moden (5/23/2009)

    If I understand correctly, this is a stored proc that processes a single row? If it's used in conjunction with a GUI, that's probably ok....

    --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 23, 2009 at 12:42 pm

    #999362

  • RE: Query Elapsed Time

    RBarryYoung (5/23/2009)

    Jeff: this is a typo, I think:

    Jeff Moden (5/23/2009)

    If so, then as Barry suggests, you have to measure it's performance over time and having the limit of 1/3rd...

    --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 23, 2009 at 12:34 pm

    #999357

  • RE: The Real SQL Server Experts

    Despite their undoubted depth of their knowledge and frightening intelligence, those in charge of the T-SQL language at Microsoft often lack recent frontline experience. In this respect, they are less...

    --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 23, 2009 at 12:27 pm

    #999354

  • RE: Google search

    ningaraju.n (5/22/2009)

    Thanx Friend

    but i have 200 to 300 tables in my db... i have to apply search for all tables like i descriged above .... i think its not good...

    --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 23, 2009 at 12:19 pm

    #999352

  • RE: PIVOT QUERY HELP NEEDED

    martin.edward (5/23/2009)

    I need to understand more about queries If am to move from the simple SELECT statements to t-sql dynamic queries. Where can I start ?

    Start here for a stong...

    --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 23, 2009 at 11:31 am

    #999351

Viewing 15 posts - 43,666 through 43,680 (of 59,063 total)