-
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…