Thanks Gethyn, appreciate it.

EDIT: http://episteme.arstechnica.com/eve/forums/a/tpc/f/833003030931/m/639000063041

I can't believe my head came up with a method of actually trying to allow RAID1+0 onto 2 disks which would be totally pointless and...

I found this forum question that could explain how HP handle a 2 disk RAID1+0...

http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1268171604049+28353475&threadId=810050

So in my situation, we have 2 146gb disks making up Array 1.

The files are striped...

sp_updatestats will do all user defined tables.

I would say that is not by design as you have turned "Not for replication" on at the publisher. When it inserts at the publisher it should seed the next...

In the absence of the smart solution have you considered an ugly process of a trigger updating a logging table everytime the column gets updated, and running a profiler tracking...

http://support.microsoft.com/kb/929491

This one is new to me. Helps a lot.

I am now seeing one of our old servers that performs hideously (not helped by just 1 physical partition for EVERYTHING and...

EDIT: Thought I'd worked it out but haven't.

Let's use one of my existing servers as an example...

Partition 1 Starting Offset is 65536. Partition 2 Starting Offset is 11476746240 (11gb...

We have a lot of boot happy SQL users on this forum! 24/7 production servers could do without that...

Thanks for that. The Server A scenario is sadly real - or is reporting as such anyway. Under the HP Smart Array utility it is showing as RAID1+0, but is...

One quad core cpu and 8gb ram...

Thanks for the feedback. Our current server is a strange fish. Keeps up to date with replication every 30 minutes but only has a big transaction hit once a month...

IF you find a solution. Sadly many of the "useful error messages" I've come across in SSIS have only been solved by service packs. Not so much an error I...

Thanks guys.

I can confirm all indexes are where they should be and the query is ok. It can run in 50 minutes on another server. On this one it can...

Stating the obvious but I take it if you open the config file you can see the password set within?

EDIT: And under the job step properties it is pointing correctly...

Use some of this. You need to throw a query in to look up jobs scheduled in between 2 and 3pm using sysjobs and sysjobschedules (off top of my head).

Then...