May seem like overkill, but could you post the EXACT SQL code you are running?

Sometimes, you just have to question people.

The only blocking you should see would be the result of attempting to access rows that are being updated in that particular batch as long as it hasn't escalated to...

rudyhinojosa2007 (12/11/2009)

---

Paul Neilsen originally created the 1.04 package, but it only supported a table with one primary key. I revised the scripts to handle up to 3 primary keys...

Thank you for the feedback. We'll try to answer any questions you may have.

Since this is SQL Server 2005, you can save the Actual Execution plan as .sqlplan file and upload that.

Actually, without seeing the actual package, it depends on the scope of the variable. If you declare a variable in a FOREACH container named MyForEach1, you won't see that...

Albatross

I have to ask the same question, why? Usually, SQL Server works better the more memory it has...

I'll give you a hint since you haven't shown us what you have tried so far, in BOL (Books Online, the SQL Server Help System that you can access by...

Isn't amazing what happens when you finally provide what you have been asked for several times? 🙂

That is why I kept asking you to read the article and provide the...

axe

ray 78019 (12/10/2009)

---

<< Why do you have questions that could be answered by yourself on a test system within an hour? >>

Bru, if you look at the left side of...

I wrote the article Deleting Large Number of Records[/url]. Take a look at the code for SQL Server 2005, you should be able to use that as a starting...

clive-421796 (12/10/2009)

---

Hi Lynn,

the procs we have use the following variations:

@StartDate = '2009-11-01'

@StartDate = '2009-11-01 12:00:00'

@EndDate = '2009-12-01'

@EndDate = '2009-12-01 23:59:59'

2 months ago I had to use your method below:

WHERE

...