Since the Informatica tool is handling the read and update then I can't use something like that.

As I mentioned, the clustered index is based on the update's fields.

Have you considered a validation constraint on your insert rather than a cursor?  But 2,500 records isn't much in the scheme of things as long as the checks aren't too...

"Have you tried running SQL Profiler to see what queries are being run against the database?

yes mostly the Select, Update queries are running on DB."

Are you doing updates at the...

Oops, nevermind, the detach and reattach changed the owner and I didn't notice.  Got it going now.  Thanks anyway!  Doh!  >slap self<

The statistics updated without a hitch (and ran much faster than the last time with the old disk configuration, woo-hoo!) but dbcc dbreindex still says it isn't in sysobjects.

Thanks; any...

Thanks for the confirmations and additional advice!

We've already got #2,3,4,and 5 planned out.  Well, #5, about the backups, we're going to stash those on a partition of what we expect...

Yes, I'm sure you did, but I bet you weren't using MS SQL Server on said Unix system's RAID.  You are definitely right that fiddling with...

Update / correction: 

We aren't going to use 'ALTER TABLE ... ON <filegroup>' because all the tables will be in the same new place and that's the wrong command and...

No, AD\Users are not sysadmins.  I am in an AD group membership for admins.  Maybe it can't verify the wider AD admin group but the admin for the laptop still...

Yes, it was these system statistics that were causing the problem.  I looked at the table with 2005's management studio and they are all listed neatly in their own category...

It's too large a table to post here; it's a stage to hold a source system dump that's over 350 columns.  But I did have the thing script the create with any...

I ran that and it didn't return any results.

Thanks for the suggestion.  Any other ideas?

Intel's website will tell you all about the different models of server class chips and the specs for each regarding 64 bit, dual core, etc, etc.  Also, your sales rep at your...

Have you considered locking by page or row instead of table?  This needs a lot more overhead (especially by row) so your physical server needs to have plenty of spare...

Is there something else running on this server that needs memory?  Why not let it dynamically allocate instead of setting a max?  In systems with >3GB SS is supposed to gobble up...