Tag: Microsoft SQL Server

Magic Knobs in Replication Agents

Have you ever wondered about tuning your replication configuration to achieve better performance or you got into a situation of huge latency and were looking for an easier way to tune it. In this blog post, I will explain the…

Read More >

Column Store Indexes in SQL Server 2012

Introduction: We will discuss Column Store Index and will try to understand the performance improvements of the same query by multiple times using column store index. What is Column store Index: Column Store Index is a feature introduced in SQL Server 2012…

Read More >

Log Buffer #343, A Carnival of the Vanities for DBAs

One key success factor in a great leadership is to gather great people around you. Bloggers are people, and this Log Buffer Edition enables you to gather them around you through their blog posts.

Read More >

MSDB – Cleanup is necessary

Recently I have been asked to work on the task which is to reduce the size of a MSDB database. The MSDB has grown to 20 Gigs. Well, you would say, what is the big deal with that? 20 Gigs…

Read More >

Log Buffer #342, A Carnival of the Vanities for DBAs

Naysayer within us keep on erecting new obstacles, especially when it comes to the creativity. Our database bloggers are winning this fight within and producing gems of blogs. This Log Buffer edition celebrates their victory.

Read More >

Log Buffer #341, A Carnival of the Vanities for DBAs

Extreme performance is the key to excellence. One example of it is the winning of 34th America Cup by Team Oracle USA, another example is the Pythian’s legendary love of  data, and this Log Buffer edition loves the blogs again,…

Read More >

Log Buffer #340, A Carnival of the Vanities for DBAs

Education is everything. Education can pull you out of poverty, it can propel you into upper echelons. Education can make you see what’s truly important in the life. Education can enable you to appreciate the people. Blogging is all about…

Read More >

In-Place Upgrade failure from SQL Server 2008 SP1 to SQL Server 2008 R2

Recently I was trying to upgrade SQL Server 2008 to SQL Server 2008 R2. The upgrade failed with error message below.   TITLE: Message Details —————————— The Instance ID ‘MSSQLSERVER’ is already in use by SQL Server instance ‘MSSQLSERVER.INACTIVE’. To…

Read More >

Log Buffer #339, A Carnival of the Vanities for DBAs

Tablogs are the blogs written, read, and managed on tablets. They are not only growing in numbers, but the volume of content is also immense. So much ease and so much power through touches ensure that you only spend time…

Read More >

Troubleshooting Transactional Replication Latency Using Agent Statistics

In this blog post, we will look at how you can leverage the Agent statistics to troubleshoot the replication latency issues. Before understanding how to decode the agent statistics, let’s take a look at the some of the basic things…

Read More >