Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)

  • RE: Index question for the guru's out there...

    Yeah, I'm starting with about 8-9 indexes across the whole system, which *should* impact about 30-40% of the activity (conservative estimate), which *hopefully* will make the rest of it faster...

  • RE: Index question for the guru's out there...

    I could get into that, and then get stonewalled with the "freeze" (aka "don't change *anything*"). There's just too many people that have to buyoff on *every* change.

    Right now we're...

  • RE: Index question for the guru's out there...

    too true, but I don't own the apps (at this point), just the SQL server tuning / maintenance stuff (itself). This project is an "extra" one I'm helping out on...

  • RE: Index question for the guru's out there...

    Thanks guys!

    I'll just do the top 3-4 indexes and only cover the columns of the smaller queries (that way I can be sure I won't hit any issues with the...

  • RE: STRANGE SQL + DOS Question

    That's not a bad idea. Hmm...maybe to a RAMDRIVE mapped as a network share...that would work since the multiple file IO wouldn't be a constraint.

    What I'm looking for (ideally) would...

  • RE: STRANGE SQL + DOS Question

    Yeah - I'd love to do that, but this is for live status of the nodes as they reboot and enter a (pure) dos mode for some work, then reboot...

  • RE: Update with an inner join

    wow, I can't believe I missed that about the lefts. Sorry about that. I'll just stick more with lurking before I post... 🙂

    Jeff, thanks for those guidelines.

  • RE: Update with an inner join

    my mistake, I see what you're doing now.

    the select would tell you that you have the criteria correct, and hopefully will give you a better idea of what's missing that...

  • RE: Weird select behavior with a "WHERE ADate LIKE @tmpDate" in sp

    Thanks, Lynn, those WHERE clauses work.

    I like the childID is null, saves a query...

    Thanks John for the explanation, much appreciated!

    -Chad

  • RE: Weird select behavior with a "WHERE ADate LIKE @tmpDate" in sp

    I'd like to be able to use something like:

    SELECT [ChildXAdmitID], [ChildID], [AdmittedByStaffID], PrimaryReasonCodeID AS PCode, carl.AdmitReason AS [PrimaryReasonCode], SecondaryReasonCodeID AS SCode, carl2.AdmitReason AS [SecondaryReasonCode], [LastSchool], [AdmitDate], [RejectDate], [ReleaseDate], [TS]

    FROM [CRH_IO].[dbo].[ChildAdmitRecords]...

  • RE: Update with an inner join

    it sounds like you want to do:

    INSERT INTO TableC (or #tmptbl whatever)

    SELECT * FROM A WHERE A.ID IN (SELECT ID FROM B)

    UPDATE TableC SET [TargetField] = ?? WHERE ???

    Then update...

  • RE: Weird select behavior with a "WHERE ADate LIKE @tmpDate" in sp

    Here are the create scripts for the 2 tables.

    The only thing out of ordinary I'm trying to do is do 2 inner joins to the SAME Lookup table because we...

  • RE: Update with an inner join

    try something like:

    SELECT a.id, a.Name, a.Address, A.Number, A.Employer, B.Zip

    FROM 1sttable 1tablealias

    INNER JOIN 2ndtable 2ndtablealias

    ON a.id = b.id

    so if the tables were A = People, B = ZipTable

    SELECT...

Viewing 13 posts - 1 through 13 (of 13 total)