I'd set up a Profiler trace, filtering for the Transaction table, to record the sequence of events that lead up to the error happening. This should give you some...

Nothing to do with the question, but an observation all the same ...

I suggest you be very careful when posting any sort of data, XML or otherwise, on public forums....

No, hotspot isn't history - it's a fact of life.

GilaMonster is quite right to say that there are no hard and fast rules about where to put a clustered index....

Your index:

CREATE INDEX [indi_id_steve_idx1] ON [dbo].[I$_DW_INDIVIDUALS]([INDI_ID]) ON [PRIMARY]

GO

gives absolutely no additional benefit over the unique index that is already there. I'd make the unique index a unique...

I don't think so.

The checkpoint process causes modified data pages to be flushed to disk, and additionally writes a checkpoint marker in the transaction log. This happens about once...

Just a quickie on the errorlogs ...

If you run the command sp_cycle_errorlog from QA, this will move all existing errorlogs down by one archive number, and put a new one...

Jai,

Even adding 1Gb more memory isn't really going to help much. Currently, the machine only has 2Gb, so the most you can really allocate to SQLServer is about 1.7...

Adam,

With SQL2000 Enterprise on Windows 2000 Server you can give up to 3Gb to the SQLServer without having to resort to the AWE extension. However, you WILL have to use...

I would strongly recommend that you DON'T use a massive IN list like you are proposing. I have seen this break a server (stack overflow) - admittedly the person...

Why don't you just generate a script on the SQL2000 server that drops/recreates all the Windows users in each database, and then run this script against the 2005 server? ...

I'm not sure what your relationship with your boss is like, but if it won't risk you being sacked my first reaction would be to ask him how on earth...

Greg, the rule of thumb should be that columns that appear ONLY in the SELECT list are trivial, and should not be the first column(s) in your index.

If those same...

No, it makes absolutely no sense to add the /3Gb switch if your box only has 2Gb in total. In fact, it could make things worse - the /3Gb...

I presume you've run the Sybase ODBC Administrator or the Sybase OLE DB Configuration Manager first? If so, can you run a successful test connection from within either...

Check in TaskManager to see how much memory your SQLServer process is actually using. If it is using 1.3 Gb itself, check the server properties through Enterprise Manager (right-click...