Are you sure dbo is the owner of the table.

I would open enterprise manager and confirm dbo owns the tables.  I have worked on some systems that they gave the...

If Vantive_ID has a unique index on it, meaning it can't share a value with any other row in the table.  You...

I would start by looking at the table you are inserting into and looking at the structure of the unique index.

One of the items in your insert statement already exists in...

Just take the go statements out.

Tom

How big is the log file, and how big is the datafile.  The database freespace includes the unused portion of the log file.  So if that 5gb is mostly free...

I would look to see if your database is trying to grow while the inserts are happening.  That will slow the insert time considerably. 

You can issue: sp_spaceused  to see...

Constraints are also not kept in sorted order like indexes.

Tom

I would find the table that sysindexes is refering to and drop the index on that table.  Run the check again and see if there is still an error in...

Make the non-clustered index a covering index by adding the salesamount field to it.  ie.  Item, Store, Saleweek, salesamount.  This will eliminate the bookmark lookup which I imagine is causing...

Try to create an odbc connection to the as400 on the sql machine and then create a linked server for odbc using that dsn.  I never got the ibm oledb...

Is this a new table that you are trying to load into or an existing one.  I use linked servers all of the time to an as400 and as long...

I had a direct attached tape device and created a tape backup device.  We ran fulls nightly transaction logs every 2 hours and differentials at noon and 6pm.  I've never...

Just because I'm feeling a little bitter today, Your boss is probably the same person that code select * from table instead of a list of columns.  That's good design...

Thanks for the replies.  I am not 100% sure when we are installing this but when we do I will let all know how it goes.

Thanks

Tom

Here is your query back using a bucket approach.  I would be interested to see if performance is different using the case instead of the if.

Let us know.

Tom

SELECT CLIENT

,  sum([SHORT...