The Ji Village News

Author: Haidong Ji

  • Drop all indexes in Sql Server 2005

    Here is a script I wrote to generate a script to drop all indexes that are not primary keys. This works for Sql Server 2005. The main thing it uses is sp_MSForEachTable, an undocumented stored procedure. Run the generated script, and you will be good to go. This is especially useful before a bulk load…

  • Oracle 10g Express Install Part 2

    After my last failed Oracle 10g Express install due to insufficient memory, I purchased some memory from eBay, and started it over. This time, the first thing the installer noticed was that the swap file is not big enough. I fixed that by doing a total re-install of Fedora Core 2. Yeah, I know that…

  • Katmai installation notes

    I downloaded and installed Katmai, code name for Sql Server 2008, a few weeks ago. My friend Scott Whigham has a great post on it. Here are some of my own observations: 1. The installation process is very similar to that of Sql Server 2005. Here is one screen shot of feature selections: 2. If…

  • 打扑克/Let’s play poker!

    Below is something I wrote a couple of months ago for my son, to help him prepare for his Japanese speech. The teacher presented a list of interview questions to me, which I replied in writing. I was organizing my files and came across it. I made slight editing to the original. Why do I…

  • Some skateboarding and fishing pictures

    Skateboarding Fishing at Mom’s hometown in Sweden We did the fish showing off thing. Not too sure how I feel about it now. Benjamin caught this big one. He didn’t want to hold it. The carp (?) was then quickly released. This bluegill is one of his first catches ever. He caught it at Morton…