Check out this blog post about the fix.

I think in the case being pointed out by Sliverfox, that the answer was a little brief, but not necessarily inappropriate. I would have probably would have included a...

GSquared (9/28/2009)

---

Jack Corbett (9/18/2009)

---

You could also take the OR's and do a union instead.

Select

From

table

Where

column between a and b AND

...

ALZDBA,

Thanks for the feedback. I know that 24 hours isn't a long period, but in this case I thought it was long enough because at least 1 of...

Great...

Based on the information you have provided, I don't know of another way to do it because as long as you are tracing SP:Completed, etc... you will collect the information...

Sorry for the late reply. The AutoGrow events are in...

The best resources I've found for this are in the last 2 articles linked in my signature.

If you can use a LEFT JOIN then I'd suggest that at is a set-based operation, while the Lookup Component is RBAR. Granted SSIS is designed to be fast...

Check out this article[/url]. Essentially you need to do your deletes in smaller batches and commit the transactions sooner.

A server-side trace might be a better way to go than Profiler as Profiler tends to have a larger perfomance impact.

Based on Linchi's post and your explanation of the process I'd say this is the expected behavior.

It should be noted that my trace was only capturing events where a certain...

I'm basically with Grant on this one. If I know the source and I know that they are conscientious about testing I'll usually use it, although even then I...

You can try to identify the parameter(s) for which it seems to work best and use OPTIMIZE FOR or you can create a PLAN GUIDE that works best for the...

You can't do it in one statement. You could write a script that creates a script for you like:

DECLARE @sql NVARCHAR(4000)

SELECT

@sql = COALESCE(@sql, N'') + N'Alter Table ' +...