The Ji Village News

Category: Technology

  • Hot fix for SP4 is cluster-aware

    Service Pack 4 for Sql Server 2000 introduced a bug. After it is installed, if Address Windowing Extentions (AWE) support is enabled, a single instance of SQL Server 2000 can only use a maximum of 50 percent of the physical memory that is on the server. Microsoft has a hot fix for that problem here.…

  • CTAS and Select Into

    In both Oracle and MySQL, you can do: create table T1 as select * from T1 This CREATE TABLE AS statement basically clones table T1 with its structure and data in T2. This can be pretty handy at times. The equivalent of that in Sql Server is SELECT INTO. For example, you can do: select…

  • Sql Server GUI display setting for easy viewing

    This is a little note for myself, when overhead projector is involved. Your milage may vary. Query Analyzer, options window: General tab: change Query File Directory to c:\MyPreferredFolder Fonts tab: Editor -> Arial Black, size 16 Fonts tab: Results Text -> Courier New 18 Fonts tab: Selected Text -> Foreground black, Background yellow Windows display…

  • CD writing in Windows XP and ISO Recorder

    A couple of things learned while rebuilding my home pc: 1. If you have Windows XP and a CD or DVD rw drive, you do not need Nero, EasyCD Creator, Roxio, or any other third-party software to write stuff to your CD; 2. A free utility for Windows XP, called ISO Recorder, allows you to…

  • Knoppix 3.6 saved the day

    For reasons not clear to me, our Windows XP machine at home died recently. It just wouldn’t boot, after trying safe mode, last known good, etc. This machine is an HP Pavilion 513x, around 6 years old. We had a bunch of children’s game software on it, along with other stuff, such as picture and…