You could use the EXISTS statement:

DELETE FROM TableA WHERE EXISTS (SELECT 1 FROM TableB WHERE TableA.Key = TableB.Key)

I have no idea how to use OVER and PARTITION and I hardly use ROW_NUMBER (probably out of ignorance), but just for fun I wrote a script that I...

How you typed it seems correct. I am assuming that the trailing comma is a typo. There are hidden dangers with not specifying the columns you are inserting....

If you need to include description and the valid column you would just need to add it into values list:

insert into table (ssn,empid,race,description,valid)

values (

@ssn,

@empid,

You should be able to write it with the case statement as a field. So it would look like this:

insert into table

values (@ssn,@empid,@race,

CASE @description

WHEN 'deputy' THEN 'Y'

WHEN 'civilian' THEN...

I am sure there is a simpler way to do it with SSIS, but if I were to do it using a simple tool set it I would use a...

Thanks! I will keep an eye on it. I have given our server team a lot of information to check on our virtual setup and they feel confident...

What is the best method to monitor that? Is there a way to monitor that by process or is it something that I just have to watch on perfmon...