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

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

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

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

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

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

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.

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

Thanks, Lynn, those WHERE clauses work.

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

Thanks John for the explanation, much appreciated!

-Chad

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]...

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

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

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