A couple of thoughts..

Partitioning and BCP seem to work nicely. For the case where partitioning is not setup I like BCP, batching up the process helps too. BCP...

one more variation:

EXECUTE master.sys.sp_MSforeachdb 'USE [?]; IF DB_Name() NOT IN (''Master'', ''Tempdb'', ''model'', ''msdb'' ,''distribution'')

BEGIN

PRINT ''Database: '' + DB_NAME()

EXEC sp_changedbowner ''sa''

END

'

go

Yes, log shipping

Mike:

We're runnning the same configuration in a high volume OLTP system for more than 8 months. Everything seems fine.  The issues that we are running into centers around perf monitor.  I...

THX for everyones input...

Add a query or workload to query analyzer, and run the index tuning wizard

Garth:

the first thing I do when I get this error is make sure that I can ping the Server from the client I am using.  (Addressing the SQL server does...

Change the order of the insert statements.  Note the paymentType insert is last.

If @payCode = 'Cheque'

INSERT INTO ChequePayment(paymentId, locOut, bankName, branchName)

VALUES(@invoicePaymentId, @locOut, @bankName, @branchName)

Else If...

Hey Chris:

Neither of DBCC commands is necessary after a re-index, I’m assuming your talking about a DBCC DBREINDEX.   See Create...