Forum Replies Created

Viewing 15 posts - 31,126 through 31,140 (of 59,101 total)

  • RE: how to make this batch file work using xp_cmdshell?

    Ummmm.... ok. I'm confused. You have the /QUIET switch set... why would you expect to see anything?

    --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 15, 2012 at 4:49 pm

    #1447612

  • RE: Monthly Report Query

    Koen Verbeeck (2/15/2012)

    Jeff Moden (2/15/2012)

    Are you really serious? You're generating a report with nearly 6 million lines of output? Who's going to read THAT?

    Usually the business imports the...

    --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 15, 2012 at 4:29 pm

    #1447609

  • RE: Finding out Total Disk Space in TSQL

    harpreets.singh (2/15/2012)

    Hi Jeff,

    Try it and let me know if it works.

    I have tested this script on several servers.

    regards,

    Harpreet

    BWAAA-HAAA!!!! Not the way it works. Since you're the one...

    --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 15, 2012 at 3:40 pm

    #1447595

  • RE: Order by While inserting

    ScottPletcher (2/15/2012)

    I thought it depended on whether SQL thought it was "necessary" or not.

    Whether the number of rows, etc., met whatever magic criteria SQL went by -- which are 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 15, 2012 at 3:37 pm

    #1447591

  • RE: Quick Hints for using the RAISERROR Command

    Richard Moldwin (11/23/2005)

    T-SQL programming involves a major loss of productivity, compared to any other modern language I know of.

    I know it's a wicked old post but the comment above...

    --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 15, 2012 at 12:51 pm

    #1447509

  • RE: Monthly Report Query

    adeel.imtiaz (2/15/2012)

    1. Query Monthly report (A1)[font="Arial Black"] with result in grid[/font], it will take 4minutes and 9 seconds.

    2. Query Monthly report(A1)[font="Arial Black"]with result in text[/font], this time it has taken...

    --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 15, 2012 at 12:42 pm

    #1447504

  • RE: How many indexes is too many ?

    isuckatsql (2/15/2012)

    Thanks for your feedback!

    I thought that dynamic SQL was faster than 'normal' SQL, which was the reason for using it.

    It seems to have made my queries faster!

    It can appear...

    --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 15, 2012 at 12:36 pm

    #1447501

  • RE: Count Function

    jennigirl (1/18/2012)

    I can get a total count of rows returned, but I am trying to get a count of tickets assigned to each person. I don't work a lot with...

    --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 15, 2012 at 12:29 pm

    #1447496

  • RE: Old Dog, New Tricks

    Gary Varga (2/15/2012)

    Rod at work (2/14/2012)

    jcb (2/14/2012)

    Jeff Moden (2/13/2012)

    ...

    Heh... even without that bit of nightmarish code, I still find the same to be true... "sad bugs" and "bad coding".

    Sure, someday...

    --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 15, 2012 at 12:26 pm

    #1447493

  • RE: Old Dog, New Tricks

    jcb (2/14/2012)

    But that remember me hot discussions with a team of old dogs.

    Hey HEY!!! Be careful now! You're talking to an "old dog"! 😉

    --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 15, 2012 at 12:24 pm

    #1447491

  • RE: Finding out Total Disk Space in TSQL

    harpreets.singh (2/15/2012)

    I tired to use powershell to get drive space info.

    Did it work? 🙂

    --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 15, 2012 at 12:23 pm

    #1447490

  • RE: Order by While inserting

    ScottPletcher (2/15/2012)

    I think the order does matter for the clus index and whether it gets fragmented or not. SQL is coded to recognize sequential inserts and not cause page...

    --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 15, 2012 at 12:21 pm

    #1447489

  • RE: Primary Keys are necessary for good database design

    SQLKnowItAll (2/13/2012)

    cw.izatt (2/13/2012)

    Jeff Moden (1/9/2012)

    @cw.izatt ,

    Did you actually check for an absence of FKs or just an absence of PKs? I ask because UNIQUE constraints will suffice for the...

    --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 14, 2012 at 7:22 pm

    #1447119

  • RE: Order by While inserting

    ScottPletcher (2/14/2012)

    Very interesting post by Conor.

    I referred to the clus index only. I assumed you can't control any other index(es), nor a heap (the ORDER BY would be irrelevant...

    --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 14, 2012 at 6:58 pm

    #1447114

  • RE: Order by While inserting

    SQLKnowItAll (2/14/2012)

    ScottPletcher (2/14/2012)

    Be careful with phrasing: MSDN doesn't say it doesn't work, they say it's not guaranteed to work.

    I believe that in this case, the clustered index is on the...

    --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 14, 2012 at 6:54 pm

    #1447111

Viewing 15 posts - 31,126 through 31,140 (of 59,101 total)