Jerry--

There are some issues if you are running AWE extended memory on the server.  Microsoft has some hotfixes that will take care of this.  A search for SP4 and AWE...

We use this script to shrink the log files--

replace the database name and use the logical log file name and you are in buisiness.

USE accutrack

GO

CHECKPOINT

GO

BACKUP LOG accutrack WITH TRUNCATE_ONLY

GO

DBCC SHRINKFILE...

If the schema is the same on the two databases, a DTS package would work rather easily, if not, well...

Terry--

I'd give serious consideration to using a GUID as your Unique Identifier (customer_id) and not try to use information that is changeable such as phone numbers or names.  The rub...

You can save your TFF files to an Image (BLOB) table field, but making it searchable could be another story.  You are basically saving a huge binary stream that is mostly...

A couple of things come to mind:

SP4 broke AWE and there arehotfixes available from Microsoft to fix it

Make sure that the switches in your...

We use the rowcount technique to delete about 30% of a date range 'state' table every night prior to rebuilding with the days inventory transactions.  The fully loaded table is...

We do something like this:

SET NOCOUNT ON --turns off network chatter

-- this will batch deletes into 5000/transaction

-- change rowcount to the value that you wish to delete in a batch

SET...