Forum Replies Created

Viewing 15 posts - 36,226 through 36,240 (of 59,099 total)

  • RE: Are the posted questions getting worse?

    Roy Ernest (10/28/2010)

    Grant Fritchey (10/28/2010)

    Brandie Tarvin (10/28/2010)

    Waving to Grant across the interwebs while listening to him present on execution plans!

    Oh, that was you? Sorry I didn't wave back. Man, I...

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

    October 28, 2010 at 5:56 pm

    #1243939

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/28/2010)

    <snicker> Today's Sandra and Woo[/url] offers a reversal of the Dilbert paradigm.

    BWAA-HAA!!! What makes that so incredibly funny is that it's so incredibly true.

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

    October 28, 2010 at 5:48 pm

    #1243936

  • RE: Ordering by month, show name

    Heh.., and I'm not the only one... I believe that Wayne S may have beat me in submitting the first article in this series.

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

    October 28, 2010 at 10:06 am

    #1243677

  • RE: Ordering by month, show name

    David Burrows (10/28/2010)

    Grant Fritchey (10/28/2010)

    Jeff Moden (10/28/2010)

    Task complete. Submitted article via "Write For Us".

    Over-achiever.

    Meh! Jeff probably hasn't heard the saying 'Nobody likes a smart a$$' 😛

    BWAA-HAAA!!!! Smart as...

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

    October 28, 2010 at 9:58 am

    #1243669

  • RE: BCP in

    jez.lisle (10/28/2010)

    I have been googling Bulk Inserts and found this below... I have tried and it seems to work very well at the moment.

    http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file

    Thanks for all the help...

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

    October 28, 2010 at 9:56 am

    #1243667

  • RE: Are the posted questions getting worse?

    Tom.Thomson (10/28/2010)

    Jeff Moden (10/27/2010)

    If you wanted a small jingle... (sung to the tune of "Row, Row, Row Your Boat")

    You shouldn't mention that in an SQL forum: "Row" is unspeakable,...

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

    October 28, 2010 at 9:53 am

    #1243661

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/28/2010)

    Jeff Moden (10/27/2010)

    Steve Jones - SSC Editor (10/27/2010)

    Grant Fritchey (10/27/2010)

    Look for the tall bald guy in a red vest.

    Or the hairy legs under a short skirt kilt

    GAH!!!!...

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

    October 28, 2010 at 9:52 am

    #1243658

  • RE: Are the posted questions getting worse?

    jcrawf02 (10/28/2010)

    Jeff Moden (10/27/2010)

    Great idea. As a side bar... you may not be able to tell the last time a table was accessed but... you should be able 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)

    October 28, 2010 at 9:50 am

    #1243656

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (10/28/2010)

    Jeff Moden (10/28/2010)

    Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll...

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

    October 28, 2010 at 9:48 am

    #1243652

  • RE: Get the Current Date

    Just in case anyone asks... when given the choice, I use what works. I have virtually no regard for ANSI code because I don't believe in the myth 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)

    October 28, 2010 at 9:46 am

    #1243651

  • RE: Get the Current Date

    Derrick... I have to ask... did you ever work at Grainger? I ask because worked with a Derrick Smith from Grainger Corporate Headquarters.

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

    October 28, 2010 at 9:43 am

    #1243649

  • RE: Is there any way to find who deleted the database

    Jack Corbett (9/20/2010)

    Here's a query that will find it:

    With cteObjectTypes AS

    (

    SELECT

    TSV.trace_event_id,

    TSV.subclass_name,

    TSV.subclass_value

    FROM

    sys.trace_subclass_values AS TSV JOIN

    sys.trace_columns AS TC ON

    TSV.trace_column_id = TC.trace_column_id

    WHERE

    TC.[name] = 'ObjectType'

    ),

    cteEventSubClasses AS

    (

    SELECT

    TSV.trace_event_id,

    TSV.subclass_name,

    TSV.subclass_value

    FROM

    sys.trace_subclass_values AS TSV JOIN

    sys.trace_columns AS TC ON

    TSV.trace_column_id =...

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

    October 28, 2010 at 3:07 am

    #1243402

  • RE: got a parameter sniffing example/demo script?

    GilaMonster (10/27/2010)

    Lowell (10/27/2010)

    I'd said previously that my theory is when parameter sniffing occurs, i think the saved execution plan is used to get the data on a row by row...

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

    October 28, 2010 at 3:00 am

    #1243399

  • RE: Searching on Multiple Tables

    InfiniteError (10/28/2010)

    Hi,

    I know that many sql developer here can give me clarification on this matter.

    What I want to know is that,

    For example I want to search these strings(ex. 'Asanti','Goodyear','Cadillac'), 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)

    October 28, 2010 at 2:54 am

    #1243393

  • RE: Parent/Child relationship

    Chrissy321 (10/27/2010)

    Thnaks All. I was able to reach a suitable solution using the CASE WHEN EXISTS syntax!

    That's cool... can you post your final code, please?

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

    October 28, 2010 at 2:51 am

    #1243392

Viewing 15 posts - 36,226 through 36,240 (of 59,099 total)