Linking to the Previous Row is actually really useful, showing a practical and elegant example of partitions, common table expressions, and row_number() functions in SQL Server 2005, to enable straightforward JOINs to previous and next rows. This type of query could prove very useful for Tim 🙂
Category Archives: Computing
CHESS is a cool tool
CHESS finds Heisenbugs in your multithreaded code with systematic thread synchronisation. Very cool. Multithreaded test cases are finally useful 🙂
How to connect to a Netgear DG834G router in Windows 7
Trying to connect my Windows 7 beta AspireOne to our wireless network (with a Netgear DG834G router), was receiving an unspecified error – “Windows failed to connect”. After playing with a multitude of settings, including security, access control, manual configuration and more, I discovered that changing wireless mode on the router from “g only” to “g & b” solved all my problems…
After that I went back and turned on all the security settings on the router again!
SQL server non-clustered indexes
I learned something new today which on hindsight should be obvious: non-clustered indexes can be significantly faster for index scans than clustered indexes, because they can take up far fewer pages on disk, especially for tables with many fields. Read VRohr’s blog for details.
This test blog post shows how KeymanWeb can integrate into a blog post (using Mozhi keymap in this case):