Browse by Tags

SQL Server Replication - resolving too many snapshots issues?

Published 15 April 8 6:15 AM | SSQA.net

In case you have many snapshots generated within your Replication setup and having troubles in finding what kind of scheduled job is running during the time of snapshot publication. By default you coudl take help of system catalog MSsnapshot_agents and...

Filed under: sql server, replication, snapshot, sqlagent, script, publisher, tsql, schedule

TSQL to generate blocking scenario for testing

Published 27 July 7 2:44 AM | SSQA.net

Most of the times you have observed to identify the blocking and how to resolve them. How about you need a script to generate a blocking scenario within your queries, this is to identify the blocker script is working or not. Also will help to test whether...

Filed under: sql server, blocking, query, script, tsql, tables, create