- Trust me -

CA-ERwin is NOT THE TOOL for you

When LogicWorks owned the product, it was dynamite. When Platinum took over, it was still a good tool. CA has made...

Hi George,

I'm an old IDMS ADS/O programmer, so I know the feeling. I pulled this method along with me through the years. The easiest way I know to track the...

4 million rows doesn't sound like a lot, but did you consider partitioning the data by client? Then you could BCP concurrently and each transaction is still isolated.

Henk,

This is an excellent script. I'd like to add my two cents worth on things that might be added to it to make it more bullet-proof...

1 - You only considered...

First off, I got it right (process of elimination)...

My only comment is that the question wasn't worded very well. A statistic is not an index, but is merely stored in...

It the proxy account in the same domain as the server itself?

USE MyDatabase

GO

DBCC SHRINKFILE (MyDatabase_data, 50000)

GO

DBCC SHRINKFILE (MyDatabase_data, 48000)

GO

DBCC SHRINKFILE (MyDatabase_data, 46000)

GO

.

.

.

This method always seems to be faster for me than one big...

You don't need separate drives, but for each group of instances that share a drive, they must belong to the same cluster group and have the disk resources as dependencies...

You can also try shrinking the file(s) in chunks - maybe 1 or 2 GB at a time...

I agree with David's steps, but with two additional things you might consider, if you're exporting the data out to a flat file first...

1. If the table you're inserting into is...

Steve,

In all fairness, anyone who answered 8GB or 64GB is correct and should be awarded the points.

But honestly people - get a life. Some of these people need the cheese...

Steve,

If you corrected it, how come it showed me the question phrased the same as in my email (Windows 2000 Enterprise Edition) and my answer being wrong (I answered 8 GB)?...

Three cheers for you Steve. Your heart is in the right place! When I first answered it, (right - but wrong), I attributed it to the three of you guys...

Here we go again.

Does anybody screen these before posting the question? There are several conditions that have to be met before even minimally logged transactions can occur during bulk operations.

• If...

Hey Brian,

Are you going to respond to this?

Why does this sound like a contest to see who can come up with the question that pulls the most response, instead...