Browse by Tags

How to reinitialize a merge subscription from publisher - SQL 2005 using TSQL script?

Published 11 September 7 4:3 AM | SSQA.net

Lately we have had a requirement to re-initialize handful of subscriptions to a publication within the merge replicaton setup. I was looking for a way out to achieve these operations programmatically using a TSQL script. I'm aware that using SP_REINITMERGEPULLSUBSCRIPTION...

Filed under: sql server, update, replication, monitor, merge, publisher, subscriptions

Simple steps to monitor Replication activities

Published 23 August 7 10:6 AM | SSQA.net

There are few simple steps involved to monitor the replication actvites, as usual with Replication Monitor is useful to monitor the overall health of a replication topology. Replication Monitor provides detailed information on the status and performance...

Filed under: sql server, integration, security, replication, monitor, troubleshoot, transactional

SQL Server 2005 how to find a rarely used index?

Published 18 May 7 5:31 AM | SSQA.net

For a SQL Server database having an index is always beneficial and from performance point of view too. But how about the clustered index which is occupying space on the database that is not used by any of the queries in the database. The Query Optimizer...

Filed under: sql server, indexes, databases, blocking, perfmance, blog, monitor