Disk Space Fan

by | Mar 2, 2010 | General

lifehacker.com posted an interesting disk visualization tool. http://www.diskspacefan.com/ it’s one of those things, where you think,… “yeah funny,.. eyecandy,…” but it often helps you localize your biggest harddrive waste. If not it’s still darn pretty eyecandy...

SQL Server: Update Cursor

by | Mar 1, 2010 | General

How to use an Update Cursor on MS SQL Server. Requirements: If the update-table does not have a Primary Key, the cursor is read-only. So I advise to create at least a temporary Primary Key, and delete it afterwards. Usage: DECLARE curs as CURSOR FOR SELECT * FROM...