I would agree with Larry, the key here is business requirements - what question are you trying to answer?

Joe

There is also the possibility that your application willl open a connection to the database that prevents your reindex, etc. from completing. If at all possible I would recommend...

Sounds like a DNS problem to me. Has anyone tried an "ipconfig /flushdns" on the affected servers? Your infrastructure folks may have changed the IP address or DNS...

Probably the most important thing to avoid here is string concatenation, the last thing you want to do is blindly accept user provided parameters.

The SQLCommand object allows for strongly typed...

Go for more RAM. Dual core is just fine but definitely go for more RAM - that is assuming you can run a 64-bit O/S or configure the O/S...

Rule #1 all SAN's are not created equal. Different SAN's treat disks very differently (e.g. EMC vs. 3PAR)

What brand & model of SAN are you connecting to?

Yup, the core database engine is 64-bit, that particular driver is 32-bit only... what you're seeing is a list of available 64 bit drivers. Download and install the 64-bit...

I should have clarified that, MS says to use the Oracle drivers provided by Oracle.

See http://support.microsoft.com/kb/q244661/

Linda -

Check your database options and see if switching to "bulk load" helps... depends largely on how/what the "data pump" is but it may help your throughput.

Joe

Just out of curiosity, how many drives make up your 1200GB of RAID 5 space?

Is anyone else out there running into concerns with these monster arrays composed primarily of 400+...

A database or server trigger would be a good solution for this one, rather than looking for the culprit why not simply prevent the act in the first place?

Upgrade advisor is definitely your friend in this case - even with database compatibility set to 8.0 there's no guarantee that changes to T-SQL, etc. won't break your database (e.g....

I usually go with a 20-30GB O/S partition when in a situation like yours. I prefer either 2 32GB or 2 72GB drives mirrored in hardware but that's just...

Watch yourself with this one, on a 64-bit machine you may well need to install both the 32 and 64 bit oracle drivers before you can see "it" everywhere including...

Clipper!, what version? Most likely you'll need a driver that supports old dBaseIII/IV files or Foxpro 2.6/2.8 files. Newer versions of Foxpro will read the old files natively...