Forum Replies Created

Viewing 15 posts - 361 through 375 (of 859 total)

  • RE: Table Table question with a twist

    ok here is the code. it gets a little nasty and relies on there always being 5 elements to each series and an id.

    --SET up some sample data

    DECLARE @String...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 4:16 pm

    #1483366

  • RE: Today's Random Word!

    crookj (5/3/2012)

    capn.hector (5/3/2012)

    Ray K (5/3/2012)

    ChrisM@Work (5/3/2012)

    bopeavy (5/3/2012)

    Ray K

    EL Jerry (5/2/2012)

    --------------------------------------------------------------------------------

    bopeavy (5/2/2012)

    --------------------------------------------------------------------------------

    hypothesis

    Hypothermia

    hypochondriac

    hypothalamus

    Beta thalassemia

    Beta release

    windows vista

    Windows ME :crazy:

    Mighty Excrement

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 1:22 pm

    #1483315

  • RE: Today's Random Word!

    Ray K (5/3/2012)

    ChrisM@Work (5/3/2012)

    bopeavy (5/3/2012)

    Ray K

    EL Jerry (5/2/2012)

    --------------------------------------------------------------------------------

    bopeavy (5/2/2012)

    --------------------------------------------------------------------------------

    hypothesis

    Hypothermia

    hypochondriac

    hypothalamus

    Beta thalassemia

    Beta release

    windows vista

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 12:58 pm

    #1483297

  • RE: Are the posted questions getting worse?

    some what on topic: http://www.sqlservercentral.com/Forums/Topic1294729-392-1.aspx i am starting to get to the end of my knowledge on this one. also am i at least looking in the right...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 12:57 pm

    #1483294

  • RE: Run query it takes 16 seconds run stored procedure never finishes

    pamozer (5/3/2012)

    If it were the indexes on the PracticeID wouldn't it be an issue in the query as well as the stored procedure? I eliminated the practiceId parameter all...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 11:10 am

    #1483214

  • RE: Run query it takes 16 seconds run stored procedure never finishes

    can you post the execution plans for each query. i think since ISNULL() is not SARGABLE it is causing an index scan which is slow to begin with. ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 10:48 am

    #1483199

  • RE: Run query it takes 16 seconds run stored procedure never finishes

    I think this is a big issue but im new to performance tuning so i may get a lesson as well.

    this section of code in each where clause (or most...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 10:37 am

    #1483193

  • RE: Run query it takes 16 seconds run stored procedure never finishes

    pamozer (5/3/2012)

    I have a stored procedure that never finishes. I run the query inside the stored procedure and it takes 17 seconds.

    Any thoughts? I tried using with recompile...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 9:56 am

    #1483154

  • RE: insert missing rows for duplicate tables but different databases...

    Steve Jones - SSC Editor (5/3/2012)

    Your subquery 1 after the WHERE clause looks to be pulling lots of data for the NOT IN. I think that's your problem. You need...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 9:46 am

    #1483141

  • RE: How to update/delete rows from different tables (tables have relationship)?

    marksquall (5/3/2012)

    -Actually that is what I read already in other post that you cannot update/delete all tables with one single query, each table has it's own dedicated [font="Courier New"]UPDATE[/font] query...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 9:30 am

    #1483120

  • RE: help with SQL query please

    vinu512 (5/3/2012)

    capn.hector (5/2/2012)

    vinu512 (5/1/2012)

    This does:

    SSelect * From ClientDetails

    Where InterviewDate IN (Select MAX(InterviewDate) From ClientDetails Group By ClientID)

    the problem with that query is the IN list contains the max interview date...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 6:34 am

    #1482957

  • RE: sum operation

    Im having some dificulty understanding what you want out. also readily consumable DDL and Sample data would help us out a lot. please see my signature for the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 6:29 am

    #1482956

  • RE: Getting the error - Transaction count mismatch

    after running your SP and getting the error check @@TRANCOUNT and see what you have. i would guess you have a commit in the code some where it should...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 3, 2012 at 6:25 am

    #1482953

  • RE: Improve Performance of this Purge Process

    You stated the DB was 4 TB before the purge what about after. as GSquared has eluded to if you have a massive amount of data to delete it...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 2, 2012 at 1:01 pm

    #1482651

  • RE: Convert minutes to hours

    a2zwd (5/2/2012)

    Hi

    I have a field in my table which has values in minutes.

    I need to convert to hours. I am doing this as

    CAST(col1/60 AS VARCHAR(6)) + ':' + CAST(col1%60.0...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 2, 2012 at 9:51 am

    #1482522

Viewing 15 posts - 361 through 375 (of 859 total)