SQL Server Education (by the geeks, for the geeks)
We, as a DBA, have many times been in a situation where your log reader goes into latency and no matter how much you troubleshoot it come back when it should …
SQL Server Replication Log Reader Why and How latency occurs Read MoreSQL Server Replication is a way to automate data distribution from a source to one or more destination database. SQL Server replication follows the Magazine Publishing terminology. A publisher (source instance) …
SQL Server Replication Terminology Read MoreThis is the last one in this series of SQL Server Fine – Tuning Transactional Replication Performance. While PART – 1 and PART – 2 were somehow correlated , this blog …
SQL Server Fine – Tuning Transactional Replication Performance – Part 3 Read MoreWhile many of you might have tested and implemented the SQL Server Replication stored procedure execution already, many might still be considering it and surely would be Googling or Binging around …
SQL Server Replication Stored Procedure execution- Will the subscriber Database be updated twice if the table and SP on the same table (that inserts\updates\deletes) are the articles in the same or different publications Read MoreHi Friends , Sometime back, there was a request on the MSDN forums where the OP wanted to archive the replicated partitioned tables in the publisher database . I think it …
SQL Server Replication Archiving partitioned and non-Partitioned tables (Without removing the articles from the publications) Read MoreFor comparing data in tables you don’t need any 3rd party tool, SQL Server ships with the tablediff utility which can be used to compare the data in two tables. You …
SQL Server Compare Data in Two Tables without Any 3rd-Party Tool Read More