Forum Replies Created

Viewing 15 posts - 32,326 through 32,340 (of 59,099 total)

  • RE: Parsing a document - Is T-SQL a good tool for this ?

    No... T-SQL isn't a good parsing tool for such a thing. What are you trying to parse out of the Text documents and what's the average length of these...

    --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 9, 2011 at 4:34 pm

    #1392229

  • RE: Tricky Query

    Performace Guard (Shehap) (10/9/2011)

    For that business logics , yoy could use the simple below update query:

    update TableA SET COL4=COL2 from ( select col2,col3 from TableB )AS s INNER JOIN TableA...

    --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 9, 2011 at 4:32 pm

    #1392228

  • RE: Execute Multiple Queries and Maintain Error Logs

    ALZDBA (10/9/2011)

    No doubt SSB would be the better scenario for this request(because is can carry a payload so it would only query a single row at best (in stead 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)

    October 9, 2011 at 2:06 pm

    #1392217

  • RE: Execute Multiple Queries and Maintain Error Logs

    Hmmm... Learning Service Broker would mean that I'd have to learn another SQL Server "4 letter word" 😛 but it does sound interesting. What I'd be most interested in...

    --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 9, 2011 at 12:13 pm

    #1392205

  • RE: String to rows

    yubo1 (10/9/2011)

    HI Jeff.Thanks a lot

    You bet... thank you for taking it the right 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 9, 2011 at 12:06 pm

    #1392204

  • RE: String to rows

    Performace Guard (Shehap) (10/9/2011)

    More Simple+ specific code for that business case ,you could use the below TVF

    alter function dbo.Returnvalues (@string VARCHAR (50))

    returns @TEMPTBALE table(newstring varchar (50))

    as

    begin

    declare @value...

    --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 9, 2011 at 12:00 pm

    #1392203

  • RE: SQL Improvement

    Jags2001 (10/9/2011)

    Thank you Jeff and dmoutray and the other contributors...I'm in Canada, near Toronto, and it's the Thanksgiving weekend. I'm in awe to the work you have done. Keep them...

    --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 9, 2011 at 11:48 am

    #1392201

  • RE: SQL Improvement

    David Moutray (10/9/2011)

    Jeff Moden (10/9/2011)

    Perhaps it's because I'm using SQL Server 2005 on a 9 year old, single CPU box, but I've tried the index suggestions from dmoutray's testing 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)

    October 9, 2011 at 11:43 am

    #1392200

  • RE: SQL Improvement

    David Moutray (10/9/2011)

    Strangely enough, it doesn't work for me, either! :unsure:

    I played around with it for a bit, and got it to work, though. Paste the XML into Notepad...

    --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 9, 2011 at 11:38 am

    #1392199

  • RE: SQL Improvement

    Perhaps it's because I'm using SQL Server 2005 on a 9 year old, single CPU box, but I've tried the index suggestions from dmoutray's testing above, especially the 0 second...

    --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 9, 2011 at 7:57 am

    #1392186

  • RE: SQL Improvement

    dmoutray (10/8/2011)

    Just copy and paste the XML into SQL Server Management Studio to see the graphical execution plan.

    That's just not working for me... is it because I'm using SQL Server...

    --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 9, 2011 at 7:44 am

    #1392185

  • RE: SQL Improvement

    Interesting stuff (hang on a minute... gotta get this shoe out of my mouth... 🙂 there, that's better)... I wouldn't have believed that this query could ever be helped by...

    --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 9, 2011 at 7:30 am

    #1392184

  • RE: Optimal size for a tempdb in production environment

    Gail Shaw and Paul Randall might disagree with both of us, Steve... something about the underlying allocation units and all that. But, I think they also might agree 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 9, 2011 at 7:03 am

    #1392181

  • RE: How Do You Handle Database Documentation?

    NOW you've got the right idea! 🙂 And, thanks for the feedback.

    --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 8, 2011 at 10:35 pm

    #1392162

  • RE: SQL Improvement

    Performace Guard (Shehap) (10/7/2011)

    Since no enough information about how data entity size is there , we could come up with an oustanding wokable solution to perform it perfectly as below...

    --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 8, 2011 at 10:33 pm

    #1392161

Viewing 15 posts - 32,326 through 32,340 (of 59,099 total)