sql server
test second post
hi – this is a second post with an image removed, and a blockquote inserted instead: hello from a quoted reader! and a pic back in: and a code stub: SELECT * FROM Table WHERE Column = 'TRUE' <stats state=”1″ work=”50664″ idle=”2515″> <reader fetch=”745″ wait=”50566″/> <writer write=”50664″ wait=”739″/> <sincelaststats elapsedtime=”304″ work=”0″ cmds=”0″ cmdspersec=”0.000000″> <reader fetch=”74″ wait=”0″/> <writer write=”0″ wait=”74″/> </sincelaststats> </stats>
sql server
SQL server replication – how long??
so, you have replication running on MS SQL Server; you just made a whole load of updates which were wrapped up in a transaction; you’ve applied the transaction and now replication is going about it’s way… but how long will it take?? well, there are a few issues here – firstly, the log reader agent needs to scan the SQL log to see what changes need to be replicated, and that will take time. once Read more