Nice, you can...

If you've got them defined as linked servers, give this a whirl (needs SQLPS module loaded):

$servers = Invoke-Sqlcmd -ServerInstance serverwithlinkedserversdefined -Query "select name from sys.servers where product = 'SQL Server'"...

Jeff Moden (12/13/2015)

---

I'm currently adding enhancements to the script. The code will poke a bot that will get into a car, drive to the offsite tape storage facility, grab...

Cheers for trying it, think that option is actually for Change Tracking rather than CDC (thought that might have been the case when I suggested it, but worth a try).

Seems...

Other things to consider for a custom solution: how do you control which is the active location? Point apps/connections at the right server? Transactional consistency across sites? Prevent writes on...

Cheers, thought it'd be from sys.dm_io_virtual_file_stats.

Not really seeing a problem yet to be honest. Temp tables/table variables, ORDER BY, many maintenance tasks, and any number of other processes all use...

Bloody hell. Surprised you haven't been asked to build it on Express Edition, make it a real challenge.

Step 1. While management are still high on whatever drugs they're taking, ask...

Maybe this?

$CreationScriptOptions.ChangeTracking = $true

Could you share the script you're using to get those numbers?

I/O on tempdb can be expected to be many MB as it's the working area for the whole of sql...

Cheers, can you capture the proc running in profiler? Should be able to confirm the parameter values that the proc's executing with.

Any caching set up on the dataset?

Are you running the report in report manager or BIDS/VS?

Is the dataset set to Query Type Text or Stored Procedure?

If text, is the text...

richardmgreen1 (12/10/2015)

---

We aren't using it for failover.

The mirrors will be snapshotted for use in reporting.

We need the data to run various reports on (that's on thr BI Edition server).

The mirror...

If you're lucky enough to have Enterprise Edition.

Neat solution ?

cory.bullard76 (12/9/2015)

---

But, wouldn't that just put it order? I only want the status with the most current date to display. The goal of the report is to show...