Browse by Tags

• Automation
• Multi-threading
• parallelism
• Performance
• Scripting

• Transactional replication and massive data updates

  SQL Server transactional replication has been a rather solid feature and works well for delivering data to reporting servers (among other things) in near real time. That said, it may not work too well when you need to perform massive updates on a published Read More... Posted Thursday, October 06, 2011 1:19 AM by Linchi Shea | 4 Comments Filed under: Performance, Replication, Scripting

• Find the distribution agent jobs

  There may be times when you want to look up the job names for a group of distribution agents. For instance, you may want to be able to stop all the distribution agent jobs for a given publication. How do you look them up in a script? A quick web search Read More... Posted Thursday, September 01, 2011 12:56 AM by Linchi Shea | 3 Comments Filed under: Replication

• Performance impact: implicit type conversions

  Often you see an implicit type conversion or a type mismatch causing a performance issue when it trips up the SQL Server query optimizer. A while back though, I ran into a case where a harmless looking type mismatch caused significant performance degradation Read More... Posted Wednesday, July 20, 2011 1:26 AM by Linchi Shea | 5 Comments Filed under: Performance, Replication

• Why is it good to be comfortable with multi-threading?

  If you are an application developer, you should find a new job if you can't do multu-threaded programming. What if you are a DBA? Probably not, not to the same extent anyway. Some in our community clearly realize the importance of being able to do things Read More... Posted Friday, July 08, 2011 1:19 PM by Linchi Shea | 1 Comments Filed under: Automation, Multi-threading, parallelism, Replication

• Distribution latency in transactional replication: Is a volume surge the culprit?

  If you use transactional replication, I have no doubt that from time to time you are asked to explain why there is an increased latency between the publisher and the subscriber. More often than not, this end-to-end latency is caused by latency in distributing Read More... Posted Friday, June 05, 2009 12:25 PM by Linchi Shea | 9 Comments Filed under: Performance, Replication Attachment(s): replStats.zip