Forum Replies Created

Viewing 15 posts - 18,916 through 18,930 (of 59,098 total)

  • RE: Are the posted questions getting worse?

    jasona.work (12/21/2015)

    Jeff Moden (12/20/2015)

    jasona.work (12/18/2015)

    Ed Wagner (12/18/2015)

    jasona.work (12/18/2015)

    The way things go around here this week and next, I think they should just make it official...

    Starting 7 working days before X-Mas,...

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

    December 21, 2015 at 7:31 am

    #1847117

  • RE: How to reduce Huge Log File size

    Not sure but I believe that the following command may do the trick...

    sp_removedbreplication [ [ @dbname = ] 'dbname' ]

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

    December 20, 2015 at 8:12 pm

    #1847030

  • RE: How to reduce Huge Log File size

    WhiteLotus (12/20/2015)

    Nothing stand out there ( after running EXEC sp_Who2 ACTIVE)

    I also run OPEN TRAN to check if there is any open transaction

    It said :

    Transaction information for 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)

    December 20, 2015 at 8:07 pm

    #1847029

  • RE: Update a column in the most recent record within a partition/group

    Excellent description in your post. The only thing that was missing was actual readily consumable data. I've included that in my response but see the first link under...

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

    December 20, 2015 at 7:05 pm

    #1847027

  • RE: How to reduce Huge Log File size

    It sounds an awful lot like someone has a runaway query going on. What does sp_Who2 have to say about disk IO for currently active transactions?

    EXEC sp_Who2 ACTIVE

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

    December 20, 2015 at 6:07 pm

    #1847026

  • RE: 2 Tables 1 recursive

    Jason A. Long (12/20/2015)

    I seem to recall reading something about beer popsicles... Ever see a drunk monkey with brain freeze? 😉

    (I haven't... But I'd like to... and I don't care...

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

    December 20, 2015 at 5:41 pm

    #1847025

  • RE: XIRR Calculation

    Luckbox72 (12/20/2015)

    When I run the numbers through a .net version I get the correct results.

    If that's true, why not turn the .Net version into an SQLCLR function or stored procedure?

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

    December 20, 2015 at 5:29 pm

    #1847023

  • RE: 2 Tables 1 recursive

    Oooooh! I could have a lot of fun with that...

    "Trained Code Monkey! Faithful and Agile friend. Never code alone again. Likes all sorts of code. ...

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

    December 20, 2015 at 5:07 pm

    #1847022

  • RE: how to dispaly subtotals

    Jason A. Long (12/20/2015)

    LOL... NULLs eh? Are you referring to "Missing & Applicable" or "Missing & Not applicable"? I think that's up there with religion & politics... 😛

    I was thinking...

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

    December 20, 2015 at 4:56 pm

    #1847020

  • RE: Are the posted questions getting worse?

    Gosh. The SPAM doesn't seem as bad as it was a couple of weekends ago but it's still about a quarter of the posts that are up right now....

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

    December 20, 2015 at 4:44 pm

    #1847017

  • RE: how to dispaly subtotals

    I absolutely agree with the technical idea of columns supporting only one type of data in order to actually be a "result set" even in reports. I've even written...

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

    December 20, 2015 at 4:23 pm

    #1847015

  • RE: Are the posted questions getting worse?

    jasona.work (12/18/2015)

    Ed Wagner (12/18/2015)

    jasona.work (12/18/2015)

    The way things go around here this week and next, I think they should just make it official...

    Starting 7 working days before X-Mas, each day you...

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

    December 20, 2015 at 4:00 pm

    #1847013

  • RE: 2 Tables 1 recursive

    @jason,

    I'm humbled. Thank you very much for your comments.

    It's not my job to judge but you very well deserve any and all compliments. Your now familiar "Smokin' Monkey"...

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

    December 20, 2015 at 3:47 pm

    #1847012

  • RE: No reaction on dbcc emptyfile

    I have to admit that my knowledge is a bit limited in this area and so must apologize for not being able to help. Hopefully, my response will act...

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

    December 20, 2015 at 3:29 pm

    #1847011

  • RE: Data Files on Azure

    patricklambin (12/20/2015)

    Nice question about a topic I have not used. But I have attended last year a session about Azure and SQL Server and the speaker explained how to use...

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

    December 20, 2015 at 3:13 pm

    #1847009

Viewing 15 posts - 18,916 through 18,930 (of 59,098 total)