Forum Replies Created

Viewing 15 posts - 43,711 through 43,725 (of 59,097 total)

  • 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

  • RE: Are you a Military Vet?

    bitbucket (5/23/2009)

    RBarryYoung (5/22/2009)

    bitbucket (5/22/2009)

    For those old enough to remember Korean Peace Keeping otherwise known as the Korean War

    !!!

    bitbucket, You're 75???

    Nope not 75 ... born April 1932 ... 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 11:23 am

    #999350

  • RE: Are you a Military Vet?

    Grant Fritchey (5/22/2009)

    Yep, in the Navy on Subs. Hated it, but I'm glad I did it.

    Yep... me too! Fast Attacks. Loved the Submarine Service and teaching electronics 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)

    May 23, 2009 at 11:20 am

    #999349

  • RE: Query Help

    allister.reid (5/23/2009)

    However, this kind of output sounds like something for display (user interface or reporting) so why not just do it in the application?

    I would be interested in what others...

    --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:15 am

    #999348

  • RE: Query Elapsed Time

    {approaching sensitive problem very carefully} 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...

    --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:40 am

    #999327

  • RE: Time Off

    Here's to all the men and women in harm's way that can't take time off. Thank you American Soldier.

    --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 22, 2009 at 5:32 pm

    #999257

  • RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

    Ravi Naik (5/22/2009)

    Great piece of code Jeff but i have tested it with 10000000 records and i am getting Arithmetic overflow error converting data type' :unsure:

    I am working a Developer...

    --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 22, 2009 at 11:07 am

    #999026

  • RE: What is the command using for Import and export data from database table using excel file

    Why not just use "Get External Data" from Excel?

    --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 21, 2009 at 9:16 pm

    #998666

  • RE: simple query

    shanila_minnu (5/20/2009)

    how to get the count of rows in a table...urgent

    Interview? 😉

    --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 21, 2009 at 8:48 pm

    #998662

  • RE: Time Off

    Heh... I had to look what "time off" meant.... didn't actually know those two words could be used together like that. 😛

    What's a good day off for you?

    There's another couple...

    --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 21, 2009 at 8:46 pm

    #998661

  • RE: Assign value to column depending on ROW_NUMBER()

    Jack Corbett (5/20/2009)

    You could use a CASE statement:

    SELECT

    CASE

    WHEN ROW_NUMBER() OVER (ORDER BY P.DAYSTOMANUFACTURE) 2 AND

    ROW_NUMBER() OVER (ORDER BY P.DAYSTOMANUFACTURE) < 5 THEN 100

    ELSE 75

    END AS ROW,

    P.PRODUCTID

    FROM

    PRODUCTION.PRODUCT...

    --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 21, 2009 at 8:36 pm

    #998658

  • RE: Do You Have a Problem?

    Gaby Abed (5/21/2009)

    If you have some horrible RBAR code going on for example, a faster processor or more ram may only give you marginal improvement. But optimize the database...

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

    #998654

Viewing 15 posts - 43,711 through 43,725 (of 59,097 total)