I would suggest creating a numbers table and using a split function if you don't already have one.  Search this site for dbo.Split and you should find plenty of posts...

Sqlquery, I echo what all of these guys have said, but I do want to add one thing.  Active-Active SQL Server clustering is not the same as active-active Windows Server...

I would recommend using the DBREINDEX as your primary index maintenance strategy.  I would also recommend to run DBCC SHOWCONTIG directly prior to, directly after, and 1/2 way in between...

Some of this depends on how you are accessing your SQL Server accross the network.  I would recommend looking into using DNS for the cutover.  If you are referencing the...

How long does your DBReindex take when you do run it?  How often is 'once in a while'?

For you to be able to automate the import process, the source files need to be in a consistent format.  I would recommend talking to whoever generates that source file...

Lowell is correct.  Adding a clustered index on your date columns should force the Identity column to generate values ordered by that date.  I would recommend testing thoroughly.

Yes, additional memory will help alleviate paging.

You have 2 options to increase your memory.

1. Upgrade your server OS to Windows Advanced Server.  Configure your boot.ini file to use the /3GB switch.  Configure SQL Server's Max Server...

OK, so I misunderstood and you're not working off of the system tables.  If I am understanding you now, you only want to query this single table that you've shown. ...

This will be dependant on your SQL Server 2000 version.  You will need to be running Developer or Enterprise edition.  You will also need at least 4GB of memory installed...

The current state of any object will be in the system tables.  You should not need to cross reference your 'log' table.  By the way, are you running SQL Server...

What OS version are you running?  The /3GB switch is only supported in the following Windows platforms:

Windows XP Professional

Windows Server 2003

Windows Server 2003, Enterprise Edition

Windows Server 2003, Datacenter Edition

Windows 2000 Advanced...

Well, can you be more specific as to what you are doing?  It sounds like you are doing a restore on your QA box, detaching the DB, renaming the physical...

Use the UNC path in the filename property of the TextFile Source Connection object in your DTS package.  You will have to make sure that you (and the SQL Agent if...