You could try the following, but I don't know if it will work with the tempdb files

use tempdb

dbcc shrinkfile(1,emptyfile)

Select distinct PID

From tableb b

where pid not in (

select distinct PID

from tableb b

left join tablea a

on a.id = b.id

where a.id is null

)

What version of SQL Server 2005 are you using Std/Ent? If it's STD do you see any memory trimming in the sql server logs or anything unusual there?

Thank you for your response. It confirms my findings. My client does want to leverage reporting services, so it is possible that I can deliver the scorecards in SSRS. I...

np - glad you got it working.

Under the 2005 Surface Area Configuration is Database Mail enabled? Honestely your Database Mail Icon should show up under Management either way - but if you go to start/programs/MSSL2005/Configuration Tools/SQL...

I third the Kimball suggestion. However, for a comprehensive book that covers everything about SSAS from the inside out I recommend "Microsof SQL Server 2005 Analysis Services" by Edward Melomed,...

One solution would be to schedule the job to run every day. In the first step write some t-sql code with some date functions that makes the step succeed and...

It is not mandatory to use a proxy. One security hoop a proxy can get you through is when the package does work on another server. Suppose the package resides...

Can you send mail from management studio? Is database mail configured for the server? If you try to do a "Send Test E-Mail" from MS/Management/Database Mail is it successful? Unlike...

I came to this forum to mention the inaccuracies around the table variable being stored in memory, but since that has already been covered several times I will just mention...

Actually after rereading what I originally posted and rereading TheSQLGuru's post I don't know why I took offense at all. My bad TheSQLGuru, it actually does look like you are...

Thank you Steve, I agree with what you are saying. I am not recommending any purchases be made based on the advice I received on this thread, but rather, I...

P.S. as I expected your link bared no relevance to my question as it implemented complex business logic and 35k tps instead of my desired 200 to 400 tps. If...

Thank you everybody except the SQLGuru whos comments were entirely unhelpful and implied that I am not a top level DBA.