What does the execution plan show?

Do you update statistics or rebuild indexes?

Are these drives single drives or raid arrays?

Open task manager, add the columns to it for IO, page faults,...

What's the location and type of database (transactional, data warehouse, olap, replicated, etc....) ?

One week doesn't seem like much time to fully profile, evaluate, and submit resulting suggestions, much less...

If the DBCC doesn't do it, I think your chances are getting slim.

How would using Bulk Insert prevent that? I don't see it.

Anyway, Greg, I sent an E-mail to the E-mail address you have posted with some initial scripts that you could...

As far as I know, and I've asked several buddies if they knew as well, the only way to be sure is by your dll versions. I would be very...

That's the one, phillcart.

The other article, thanks to cwedgwood50, is excellent as well. The thing is, they all say the same thing when you get right down to it. A...

I like that.

I have a question though, and I guess it could be related. I've worked with a lot EMC SAS Fiber systems using their own EMC fiber channel cards,...

In my work, I have many many text files to import. I created a system that periodically scans a directory for a particular file name I store in a table,...

I agree heartily with the guy who said to do it for personal satisfaction. I consider it a personal challenge to be able to pass the tests simply because they...

I like Greg's solution(the last one). Make the file csv.

Least load on the server as I see it.

Edited by - Scorpion_66 on 11/19/2002 4:02:01 PM

You might need to figure out some form of versioning and version checking schema to prevent procs or triggers from running if the code is not updated properly, would be...

I have seen cancelled dbcc commands corrupt databases in the past.

kknudson, tell them that's fine so long as they don't mind reduced database performance and possibility of downtime. That will get their attention, and its true, too.

Because the transaction cannot be considered committed until its committed on all subscribers in a merge replication topology, if any of them roll back the transaction (ie. fails it.) that...

yea, I was curious enough to run some tests myself after I thought about it some more. There are some quite dramatic differences bewtween the top statement and setting rowcount...