Forum Replies Created

Viewing 15 posts - 5,431 through 5,445 (of 8,753 total)

  • RE: Today's Random Word!

    crookj (5/1/2015)

    SQLRNNR (5/1/2015)

    totem

    Tikki

    Raita

    May 1, 2015 at 12:09 pm

    #1795077

  • RE: Today's Random Word!

    Revenant (5/1/2015)

    Eirikur Eiriksson (5/1/2015)

    djj (5/1/2015)

    Ed Wagner (5/1/2015)

    Eirikur Eiriksson (5/1/2015)

    crookj (5/1/2015)

    Ed Wagner (5/1/2015)

    djj (5/1/2015)

    Eirikur Eiriksson (5/1/2015)

    Ed Wagner (5/1/2015)

    Up

    Direction

    Location

    GPS

    Garman

    Brand

    Recognition

    Award

    Celebration

    Friday!

    Venus

    May 1, 2015 at 11:52 am

    #1795072

  • RE: Today's Random Word!

    djj (5/1/2015)

    Ed Wagner (5/1/2015)

    Eirikur Eiriksson (5/1/2015)

    crookj (5/1/2015)

    Ed Wagner (5/1/2015)

    djj (5/1/2015)

    Eirikur Eiriksson (5/1/2015)

    Ed Wagner (5/1/2015)

    Up

    Direction

    Location

    GPS

    Garman

    Brand

    Recognition

    Award

    Celebration

    May 1, 2015 at 11:47 am

    #1795070

  • RE: Finding Problem Code

    Eric M Russell (5/1/2015)

    Eirikur Eiriksson (5/1/2015)

    Eric M Russell (5/1/2015)

    Static code analysis doesn't know how many times the code is executed, how much data it accesses, or how it's impacted when...

    May 1, 2015 at 11:47 am

    #1795068

  • RE: remove CR-LF in between column which is text datatype

    PJ_SQL (5/1/2015)

    I have a column A as 'text' datatype. This has CR-LF in between data.

    How to remove it.

    I am trying to copy result from SQL to Excel

    Eg:

    A CR LF

    ABC CR...

    May 1, 2015 at 11:25 am

    #1795063

  • RE: Finding Problem Code

    djackson 22568 (5/1/2015)

    david.gugg (5/1/2015)

    We run a daily trace that captures SQL running longer that X seconds. This gives us a good idea of what SQL can be tuned to...

    May 1, 2015 at 10:51 am

    #1795055

  • RE: Finding Problem Code

    Eric M Russell (5/1/2015)

    Static code analysis doesn't know how many times the code is executed, how much data it accesses, or how it's impacted when running in parallel with other...

    May 1, 2015 at 10:36 am

    #1795052

  • RE: Using "Try-Catch" and "Rollback" on read only stored procedure

    Matt Miller (#4) (5/1/2015)

    only word of caution would be to check where the BEGIN TRAN is. I've seen a few doozies where the "rollback" is in a child/subprocedure and...

    May 1, 2015 at 10:33 am

    #1795051

  • RE: Using "Try-Catch" and "Rollback" on read only stored procedure

    Grant Fritchey (5/1/2015)

    .... I'll shut up.

    Didn't know that was possible:-P

    😎

    May 1, 2015 at 10:29 am

    #1795050

  • RE: Time differences between different intervals

    Jeff Moden (5/1/2015)

    Heh... I cringe every time I see something like this where the human isn't compelled to take an action such a log out. The simple solution...

    May 1, 2015 at 8:50 am

    #1795010

  • RE: How to reduce MDF file size ?

    WhiteLotus (5/1/2015)

    Eirikur Eiriksson (5/1/2015)

    WhiteLotus (5/1/2015)

    Ohh nicee thx ..now i am thinking to expand it into 5GB . What do u think ?

    That is probably fine, that would be 5120MB or...

    May 1, 2015 at 8:00 am

    #1794990

  • RE: Using "Try-Catch" and "Rollback" on read only stored procedure

    Grant Fritchey (5/1/2015)

    Eirikur Eiriksson (5/1/2015)

    Grant Fritchey (5/1/2015)

    If you're only doing a SELECT operation, there's no reason to do a TRY/CATCH.

    TRY / CATCH is as valid / useful in SELECT as...

    May 1, 2015 at 7:57 am

    #1794986

  • RE: How to reduce MDF file size ?

    WhiteLotus (5/1/2015)

    Ohh nicee thx ..now i am thinking to expand it into 5GB . What do u think ?

    That is probably fine, that would be 5120MB or 5242880KB

    😎

    May 1, 2015 at 7:42 am

    #1794982

  • RE: Today's Random Word!

    crookj (5/1/2015)

    Ed Wagner (5/1/2015)

    djj (5/1/2015)

    Eirikur Eiriksson (5/1/2015)

    Ed Wagner (5/1/2015)

    Up

    Direction

    Location

    GPS

    Garman

    Brand

    May 1, 2015 at 6:53 am

    #1794965

  • RE: How to reduce MDF file size ?

    WhiteLotus (5/1/2015)

    I want to make clear here .. it is not disk space problem but the problem is data file is too big for some user databases . One of...

    May 1, 2015 at 6:52 am

    #1794963

Viewing 15 posts - 5,431 through 5,445 (of 8,753 total)