Forum Replies Created

Viewing 15 posts - 41,311 through 41,325 (of 59,102 total)

  • RE: Inspiring Change

    Heh... actually, that's a great addition, MBN. Lots of folks forget that knowledge is ability and without the knowledge, you may not have the ability... that's the whole purpose...

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

    November 5, 2009 at 6:15 am

    #1075286

  • RE: Which 3rd Party performance tool do you use?

    Ah... now that's a horse of a different color. You'll still have many of the problems I and others have spoken of but I'm with you... take anything they're...

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

    November 5, 2009 at 5:59 am

    #1075283

  • RE: dateadd function

    Mazharuddin Ehsan (11/3/2009)

    create procedure..

    select

    sysdate + cdays

    ....

    from oracletable

    Thank you

    sysdate cannot be fetched from 'oracletable' :w00t:

    Sure it can... SysDate can...

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

    November 4, 2009 at 10:56 pm

    #1075165

  • RE: How does a View work?

    GSquared (11/4/2009)

    That means, no, it doesn't pull all the rows and then filter them. The query engine is smarter than that.

    Ummm... not always true, Gus. If a view...

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

    November 4, 2009 at 10:36 pm

    #1075157

  • RE: How to convert some Access SQL into TSQL?

    george.greiner (11/3/2009)

    Ok cool I will definitely be looking into that code later on to better understand and speed up what I am doing! Really appreciate it guys! Thanks.

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

    November 4, 2009 at 10:28 pm

    #1075152

  • RE: Output to grid file

    alark (11/4/2009)

    Hi,

    I created a shell script (Windows XP) that runs a stored procedure (SQL-2005) using OSQL ... and directs output to a file. The problem is that the file is...

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

    November 4, 2009 at 10:20 pm

    #1075146

  • RE: how to find 3days before date from prasent date

    Yes there is... please see DATEADD in Books Online. Yeah... you could just subtract 3 from a DATETIME datatype, but that won't work on some of the new DATE...

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

    November 4, 2009 at 10:15 pm

    #1075144

  • RE: Inspiring Change

    I'd encourage the rest of you to give it a try and see if you can inspire a young girl, a minority, or a child you know to consider a...

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

    November 4, 2009 at 10:05 pm

    #1075141

  • RE: Looping through a directory for sub-directories' names

    Build a Temp table to accept results from the following (using Insert/Exec) and then query the Temp table...

    EXEC dbo.xp_DirTree 'file path or UNC',1,1

    Works in 2k, 2k5, and 2k8. ...

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

    November 4, 2009 at 8:26 pm

    #1075122

  • RE: Which 3rd Party performance tool do you use?

    Indianrock (11/4/2009)

    Which tool do you use and why?

    SQL Server Profiler, and a healthy dose of grey matter.

    Why were others ruled out?

    They're available for use on every SQL Server (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)

    November 4, 2009 at 8:18 pm

    #1075120

  • RE: Preventing Table Locks: Are cursors a good idea?

    huston.dunlap (11/3/2009)

    We are creating some new update scripts that will be run on a live database. The scripts will be running on the main table for the database, so concurrency...

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

    November 4, 2009 at 7:21 pm

    #1075109

  • RE: Money vs. Decimal Data type

    repent_kog_is_near (11/2/2009)

    Jeff

    Let me try to summarize you:

    *Bigger the precision (is it and/or scale), better the accuracy,especially in multiplication by a big number (Example: 2.45454545 (precision 9;scale 2) is more accurate...

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

    November 4, 2009 at 6:47 pm

    #1075107

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/4/2009)

    Jeff Moden (11/4/2009)

    GilaMonster (11/4/2009)

    Roy Ernest (11/4/2009)

    I wonder how the Kilt day is going in PASS... 🙂

    Interestingly. Photos later.

    Heh.... gives new meaning to the phrase "What's Up?" 😉

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

    November 4, 2009 at 6:23 pm

    #1075105

  • RE: Are the posted questions getting worse?

    GilaMonster (11/4/2009)

    Roy Ernest (11/4/2009)

    I wonder how the Kilt day is going in PASS... 🙂

    Interestingly. Photos later.

    Heh.... gives new meaning to the phrase "What's Up?" 😉

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

    November 4, 2009 at 11:44 am

    #1074957

  • RE: ssis and ssrs interview questions

    Greg Edwards-268690 (11/3/2009)

    Jeff Moden (11/2/2009)

    pleasehelpme (11/2/2009)

    gilamonster,

    it's not your business how people like to answer the questions in the interview. Stop whining ok, you are annoying.

    Heh... nah... what's realy annoying is...

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

    November 3, 2009 at 10:54 pm

    #1074676

Viewing 15 posts - 41,311 through 41,325 (of 59,102 total)