I'd suggest cdc as the best option

log shipping didn't work for reporting because sadly all our reports need to issue writes ( don't ask ) to the data during generation - so I can only run...

Many of the counters don't work quite like that I'm afraid. I don't believe that the cpu counters in sys.dm_os_performance_counters actually record cpu like that. I capture cpu but...

put your backups into a sub directory. In some circumstances you cannot write files to a root of a drive. ( it's sloppy practice to write stuff to a root...

the downside of multiple step jobs or multiple commands in a step is how you handle an error or failure.

Let's say you take the approach of 1 step for each...

I'd say that most of this is happening in memory which means that the limitations of hardware are the factors here.

Do I think you can get under 5 secs -...

I believe the proc that fixes logins no longer works in sql 2008 - I usually script users in this situation as it's easier, especially with schemas unless you don't...

yeah I know but everyone understands active/active & active/passive. But I agree

Actually san replication is a software solution because you have to buy the software. But we're getting off the point. In SQL Server, clustering allows you to have an instance...

ha! welcome to a world of pain with figures so largely meaningless you can almost prove anything!!

An actual iop is a calculation based on the rotational speed of a disk...

I don't build SSRS servers very often, far less than SQL Servers, and I haven't created a build doc for SSRS 2008 (R2) yet. The install I did was to...

umm - the whole point about log shipping is that it copies everything, that's why it's the most simple but effective way to safeguard an environment, not least because every...

there's no way to have different indexing in a log shipped environment.

15k rows an hour isn't particually a heavy load, depending upon your hardware of course - benchmarking tests...

I'm not sure that a remote distributor of any sql version will always give you better performance, it all depends upon the load(s) on the servers and essentially network bandwidth.

When...

for example

alter index myindex on [dbo].MyTable REBUILD PARTITION = 11 WITH (SORT_IN_TEMPDB = ON);

partitioned indexes can't be rebuilt on-line btw.