Recommended reading from mrdenny for January 30, 2015

This week I’ve found some great things for you to read. These are a few of my favorites...
Random Unexplained Replication Job Failure in a large SQL Server Replication Topoligy

One of the environments that I work with includes a very large replication topology. While there are only a few servers involved there are dozens of publications between those servers. One of the problems that replication has is that it can only run so many agents at a time. Now remember that...
Recommended reading from mrdenny for January 23, 2015

This week I’ve found some great things for you to read. These are a few of my favorites...
Reducing Locking by “Distribution clean up” Job

Anyone who has had to manage a large SQL Server replication environment has had to deal with strange locking within the distribution database. This is because the distribution database is basically a giant named value pair database which has a TON of jobs inserting, updating, querying and deleting...
Monitoring SQL Replication Latency

When working with SQL Server replication, you don't have a whole lot of options for monitoring the latency of the replication. You've got the SQL Server Replication Monitor, and that's basically it. Well there is another option. You can manually run the code that the replication monitor uses to...
Recommended reading from mrdenny for January 09, 2015

This week I’ve found some great things for you to read. These are a few of my favorites...
If I have a filtered index, what do I need to have in my query to make SQL use it?

Filtered indexes are great, because they let you exclude rows from the index. But what do you need to include in your where clause to use the filtered index? The answer here is surprisingly straight forward. You need to use the exact same where clause value in your queries where clause as is...
Recommended reading from mrdenny for January 02, 2015

This week I’ve found some great things for you to read. These are a few of my favorites...