-
TableDiff in Sql Server 2005
TableDiff is a great tool to compare the content of tables with the same structure. It is part of replication tools, but can be used for other purposes as well. This is the requirement of the tool, as spelled out in this error message: The replication table difference tool requires the comparison tables/views to have…
-
Logo programming fun
My son had the idea, and I just implemented it in Logo. It’s been really fun. We learned typing, math, geometry, and all that together without even knowing it. We did it on Ubuntu with KTurtle. By the way, it looks KTurtle’s Logo implementation is not consistent with documentations found in other sites. The next…
-
Big Security Token cache affects performance of Sql Server 2005
I recently came across a Sql Server performance problem. It was caused by TokenAndPermUserStore taking too much of cache. Server specifications: Windows 2003 R2 SP2 Enterprise b4-bit, Sql Server 2005 Enterprise 64-bit SP2, 2 Quad-Core Dell server with 32 gig of memory Symptoms that I have experienced: 1. Over time, the application got timeout messages.…
-
In memory of Ken Henderson
Ken Henderson’s death really shocked me. I didn’t feel like working for a few days after I learned the news. I met Ken twice. The first time was when I was at PASS (SQL Server conference) in Grapevine, Texas. Then I just admired him from afar. We may have traded pleasantries. I remember attending Microsoft…
-
风雪无阻，过年平安
昨天给朋友写电邮时提到受天气影响回家过年的人们。在网上看到不少照片，很震撼，但又不能做些什么。 今天读博客，响应Likk同志的号召，给我的博客也加上黄丝带。祝大家旅途安全，过个好年！ 这个叫Likk的家伙可不简单：诗人，爸爸是摄影家，女儿是小诗人，带墨镜，开黑车，很像帮派老大。他是我最欣赏的博客之一。以下是几个很好的链接： 关于农民工子女的教育 媒体之无良