Forum Replies Created

Viewing 15 posts - 47,626 through 47,640 (of 59,102 total)

  • RE: Using xp_cmdshell

    ... and, like I suggested before, please tell us what Task.exe actually does. There may be no need for such computational shenanigans at all. 😉

    --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 24, 2008 at 6:09 pm

    #889569

  • RE: SQL Data Counter

    rishgup (10/24/2008)

    You can say each trigger update each field. Say You have table employee and address, whenever data is inserted into the table employee only emp_ins field will be incremented...

    --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 24, 2008 at 6:06 pm

    #889568

  • RE: SQL Server 2000

    Greg Snidow (10/24/2008)

    Matt Miller (10/21/2008)

    Just be sure to disable recursive triggers...:)

    Now wait a minute...no one ever mentioned that one to me before. I'm not sure exactly what that...

    --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 24, 2008 at 5:51 pm

    #889565

  • RE: SQL DB Performance

    Sandy,

    Along with the other recommendations for regular DB, index, and other forms of maintenance, if you still are having performance problems after that, there's a pretty good chance that 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)

    October 24, 2008 at 5:41 pm

    #889564

  • RE: SQL DB Performance

    Also, running DBCC commands, even (gasp) SHRINKFILE or SHRINKDB can be done ONLINE... it will slow things down a bit but the system will still be available.

    --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 24, 2008 at 5:32 pm

    #889563

  • RE: SQL DB Performance

    The_SQL_DBA (10/24/2008)

    Jeff...correct me if I am wrong 🙂

    After the shrink, as users add rows etc in the database, the file has to grow again.

    Growing a database file is an...

    --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 24, 2008 at 5:27 pm

    #889562

  • RE: t-sql using either table-a ot table-b

    balv (10/24/2008)

    The info required is found using a key and is located on table-a or table-b. The result gave the info on table-a (if available), else found the info...

    --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 24, 2008 at 5:14 pm

    #889559

  • RE: Wierd Counter!

    Garadin (10/24/2008)

    I figured I'd let you answer one of these, since I've snagged like the past 10 :hehe: (Although this one didn't quite work out the way...

    --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 24, 2008 at 1:43 pm

    #889454

  • RE: Wierd Counter!

    JohnDBA (10/24/2008)

    Jeff and Graber

    Thank you so much, and thank you for the explanation. It helps a lot to understand where my problem was. I really appreciate your help.

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

    October 24, 2008 at 1:41 pm

    #889451

  • RE: Wierd Counter!

    ggraber (10/24/2008)

    Jeff Moden (10/24/2008)

    ggraber (10/24/2008)

    P.S. You may want to read Jeff's cool article on Running Totals which explains how this approach works http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

    Heh... that's where I was going with this......

    --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 24, 2008 at 8:43 am

    #889271

  • RE: Wierd Counter!

    JohnDBA (10/23/2008)

    Please help me!

    I have this values that I need to count based on condition.

    - If the value is between 10 and 15 and the code is = 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)

    October 24, 2008 at 8:39 am

    #889267

  • RE: Wierd Counter!

    ggraber (10/24/2008)

    P.S. You may want to read Jeff's cool article on Running Totals which explains how this approach works http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

    Heh... that's where I was going with this... I just wanted...

    --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 24, 2008 at 7:31 am

    #889204

  • RE: Wierd Counter!

    AnzioBake (10/24/2008)

    The solution to this is very much like a solution I posted earlier, but not without a row identifier as mentioned before.

    So, you shouldn't have a problem posting 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)

    October 24, 2008 at 7:29 am

    #889203

  • RE: How to cast bad data

    Sorry... didn't mean to do a stab'n'run...

    Madhivanan's method works for checking for integers or, if you will, is an "IsAllDigits" check. Adding the .d0 to an integer still produces...

    --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 24, 2008 at 7:26 am

    #889198

  • RE: Using xp_cmdshell

    Dang... I forgot all about that. Thanks for the reminder.

    --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 23, 2008 at 10:02 pm

    #889017

Viewing 15 posts - 47,626 through 47,640 (of 59,102 total)