SQL Server Soldier :: News from the frontlines of the database wars

Making Sense of Replication Errors in Replication Monitor

Making Sense of Replication Errors in Replication Monitor

If you've ever had to deal with errors in Replication Monitor, your first experiences with it probably involved confusion. Sometimes the error messages are too generic and do not help you find a resolution.

Replication Monitor also tells you the…

4 comments, 2,615 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 27 March 2010

Measuring Transactional Replication Latency Without Tracer Tokens

Measuring Transactional Replication Latency Without Tracer Tokens

SQL Server 2005 introduced Tracer Tokens (SQL 2005 | SQL 2008), a new methodology for programmatically measuring replication latency in transactional replication. To measure latency with a tracer token, you simply insert a tracer token at the publisher. The replication…

11 comments, 2,411 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 25 March 2010

Twas the Night Before the MCM ...

T'was the Night Before the MCM ...

SQL Server MCM starts tomorrow. My wife thinks it's cute that I'm excited. The location is a place that I know well. It's in building 40, and I used to work in building 22 which is right down the hill. Meeting space is… Read more

5 comments, 203 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 14 March 2010

Finding Date Ranges for Calculating Statistics

Finding Date Ranges for Calculating Statistics

I received the following question from a fellow DBA:

I need your input to derive the reliability of one of the tool I am currently working …

I have table which has outagedate column with dates like below

WeeklyOutageDate
2009-12-05 04:21:00:000
2009-12-06 08:22:00:000

6 comments, 690 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 14 March 2010

Top 6 Myths of Transaction Logs

Top 6 Myths of Transaction Logs

I think there is a lot of misunderstanding concerning database transaction logs in SQL Server. I had intended to write this as the top 5 myths, but I wasn't able to narrow the list down that far.

Myth #6: I added additional log…

15 comments, 890 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 10 March 2010

T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?

T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?

This blog entry is participating in T-SQL Tuesday #004, hosted this month by Mike Walsh. You are invited to visit his blog to join the party and read more blogs participating in this month’s theme: IO.

The question was raised… Read more

3 comments, 424 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 9 March 2010

SQL LiteSpeed Error: XML returned from Engine was invalid

SQL LiteSpeed Error: XML returned from Engine was invalid

This is a very common error returned from SQL LiteSpeed. So what does it actually mean? What is the root cause?

What does it mean?

It means exactly what you think it means. When you first see it, you…

2 comments, 733 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 6 March 2010

Breaking Down TempDB Contention

Breaking Down TempDB Contention

What is tempDB contention?

From the outside looking in, tempDB contention may look like any other blocking. There are two types of contention that tends to plague tempDB's, especially when the tempDB is not configured to best practices (multiple, equally sized data files, located…

15 comments, 11,735 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 5 March 2010

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog

Archives: March 2010

Making Sense of Replication Errors in Replication Monitor

Measuring Transactional Replication Latency Without Tracer Tokens

Twas the Night Before the MCM ...

Finding Date Ranges for Calculating Statistics

Top 6 Myths of Transaction Logs

T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?

SQL LiteSpeed Error: XML returned from Engine was invalid

Breaking Down TempDB Contention