Finally! I have 120 Gigabytes to call my own! I bought a Seagate Barracuda 7200.7 ST3120026A… 120GB, 7200rpm, 8.5 ms average seek time, Ultra ATA/100 interface with an 8MB cache…Mmmmm… It should be ultra fast and ultra quiet… I can’t wait to take this beast home and slap it in my machine. Unreal Tournament 2003 here I come!
Category Archives: Software
New Computer
Kodiak was selling his Athlon XP2000+ with 512mb RAM and GeForce4 Ti4200 64mb RAM, so I bought it off him for my AMD 900MHz with 256mb RAM and onboard video and NZ$800. No HDDs involved in the deal, but he threw in Unreal Tournament 2003 and Serious Sam 2. Nice deal huh? It’s my first real decent vidcard. Pity I don’t have any hard drive space to install UT2k3… I’m gonna need about 3GBs… time for a new drive methinks 🙂
Baby’s First Kernel Re-compile
Yup, today at work I installed Debian Linux 3.0 on a box we dubbed Radar, after the character from M*A*S*H, to go along with our test server, Hawkeye. I think Klinger is the next one we’ll put together. So yeah, I did my first kernel re-compile. W00t 😉
Mother of All SQL statements
SELECT ``. * , `regions`.`regionname` ,
MATCH (
``.name_first, ``.name_last, ``.address1, ``.address2
)
AGAINST (
' runner '
) AS relevance
FROM `regions`
INNER JOIN `` ON ( `regions`.`id` = ``.`region_id` )
WHERE (
(
``.businessflag = 0 AND ``.name_last
LIKE 'runner'
)
) OR (
(
``.businessflag = 1
) AND
MATCH (
``.name_first, ``.name_last, ``.address1, ``.address2
)
AGAINST (
'runner'
) > 0
)
HAVING relevance > 0
ORDER BY relevance DESC
OK, maybe not the mother of all SQL statements, but maybe the PHP will convince you otherwise:
WITH?
(what in the hell) I was reading my email and suddenly the screen goes all blank. for no apparent reason. About 20 seconds later, my screensaver appears. Even though I was actually using my mouse. Weird.
