If you are okay with...

Couple of things to look for.

1st Result set:

Available Physical Memory

System physical memory high

System physical memory low

2nd result set:

Target Committed

Current Committed

You could run dbcc memorystatus to check the Target and the Current Committed values, but it looks like the server is only using 4GB.

Maybe I'm not understanding the problem, but to me it looks like you are not wanting to have anything happen with they are not matched by source. So don't add...

sqlbuddy123 (3/10/2014)

GilaMonster (3/10/2014)

Max server...

Are there other instances installed on this box?

This might be where my lack of knowledge with Access comes in to play. The code that you have works fine for me (on SQL Server) and I don't see...

You are correct that the cte will not work in Access. Is there anything in the record that makes it unique? i.e. an ID or a date that would be...

You can use the following to accomplish what you need:create table RemitterSemiOutput (

rtno int not null

,acctno int not null

)

insert into RemitterSemiOutput

values (1,1)

, (1,1)

, (2,2)

, (3,3)

,(3,4)

,(4,4)

,(4,4)

SELECT *

FROM ...

Oops forgot to add the caveat! Thanks Jason. Also you can use DBCC FLUSHPROCINDB(<db_id>); to only flush the plans from a single database.

You might also want to account for getting the execution plan from cache too. You can use this to clear the proc cache dbcc freeproccache.

It is good to...

At the top of Glenn Berry's DMV queries he does the work for you. Run the code and look at the comment block for which version you are currently on....

You could use Full Outer Join to compare the two tables and you can use BINARY_CHECKSUM to check the difference between rows with the same id. Like so:

drop table #tblTasks;

drop...

Like Jack mentioned above it would be really helpful if you could provide a create table script along with insert statements for your sample data. Please read the article in...

I have never noticed any performance issues with that TF. I guess you if you have a ton of deadlocks it may impact your error log, but it is a...