I see where you are going with that. This was a simple example. We are inserting many rows and have an identity field. We use the output...

In our upgrade process we use table types and tweak sprocs constantly. We found this to be the easiest way to maintain the changes. it is not the...

I was thinking of something like this. It would work and I could script it so it would at least start off automated. I could poke holes in...

I see what you are saying...I can just make it without the where clause. Thanks

I appreciate the help. I am not doing a very good job explaining this. I am going to look into it more and see if I can find...

Sorry, I can give more information.

In the parent the table is a table that has a PK on the guid (non clustered). The table is empty.

the Child table...

You would need to post the stored procedure or give us more information to help you. Performance can be lots of things

I did some auditing and I can see the mdf growing because of that one table mentioned above 3 times (500mb X 3 =1.5Gb) in 12 hours. The source...

Version of SQL is

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)

Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation

Standard Edition (64-bit) on...

The clustered index is on an int identity. There is a Unique Non-Clustered index on two unique-identifier fields

That is kind of what I thought. I appreciate the help

Yes, you have shown me my question was not clear. The question I have is a CTE would be lighter than a TVP Insert/Delete correct? If so can...

I gotta stop using loops! I know the tally works better. Thanks for the reminder. Worked great.

So I/O outweighs procedure cache?

Sorry for the delay in response. Thanks for the help. That is exactly what I needed to do. Since it was XML I had to do a...