A few months ago someone posted an updated script that lets us know what
object are in the data cache.  That message is no longer on the news
servers, and is not indexed by Google.
Can someone please repost it, thanks.

I find myself seeking a peculiar kind of performance solution.  I'll try to
convey this clearly and concisely:
-  The "database" is a collection of 10 million or more rows of data from a
spreadsheet.

How the "date correlation optimization" option affects my queries in a DW
environment?
how to compare before / after? (so what type of query is optimized or not)
Thanks.

Our client's system is an ETL-heavy system running on SQL Server 2000.
We're running a federation that consists 3 4-ways each with 16G of RAM.
Behind this is a SAN consisting of a 3G cache configured for Write, 2
processors (1 of which is shared by 2 of the servers) and I think 6 ...

We have a bit of a problem with Windows Synchronisation Manager.
Basically, we have two domain servers (not the same domain) that have a db
on a SQL 2000 SP3a server. Those servers have a merge replication and
everything works as it should until we set the Syncronisation Manager ...