-
Moon cakes of 2007
Like Prince Roy, I don’t like Chinese moon cakes during Mid-Autumn festival. This year, we got the following instead: They are cappuccino mousse, chocolate cheese cake, and tiramisu for me, our son and my better half respectively. Notice they are all round and tasty. Speaking of tasty stuff, would you like to try some of…
-
Dream language
I was in Denver this week, attending the PASS conference. I always have a good time at PASS: connecting with old friends and making new ones. Plus, it never hurts to crash a few parties, drink some beer (Rock Bottom, just so so, in my opinion), and talk with people from different parts of the…
-
Rebuild master database
Recently, the default instance of Sql Server 2005 on my laptop refused to start. Here is the message in the Windows event log: The SQL Server (MSSQLSERVER) service terminated with service-specific error 3417 (0xD59). Here is the message in the Sql Server error log: The log scan number (253:272:1) passed to log scan in database…
-
Looking for unused indexes and checking index fragmentation in Sql Server 2005
Here is a script to check unused indexes in your Sql Server 2005 databases. Once one particular index has been used, the dm_db_index_usage_stats will be updated. All this information will be lost every time Sql Server instance is cycled. Therefore, you should run it after Sql Server has been running for a while, as it…
-
More book giveaway
The first book I co-wrote, on Sql Server Integration Service, has been translated to Chinese. I have about 10 copies to give away. The second book I co-wrote, on Sql Server 2005 administration, has been translated to Italian. I have 2 copies to give away. Last time I gave my books away, I took care…