Entries from January 2009

Saturday, January 24th, 2009

Son, I see you’re a real go-getter. We hate that here. You’re fired.

Av chefen fick Niclas också höra att det är orättvist mot de andra skolorna att han anstränger sig lite extra. http://www.gt.se/nyheter/1.1440479/skolmaten-niclas-lagar-ar-for-bra Naturligtvis gäller de vanliga brasklapparna om att man inte ska vänta sig höra hela historien från en kvällstidning. Men visst känns det… typiskt?

Thursday, January 22nd, 2009

Using OPTION (FORCE ORDER) with user definied functions in SQL Server 2005

Really interesting thing I realised today: Using OPTION (FORCE ORDER) within a UDF, at least in SQL Server 2005 (i haven’t tested in other versions), doesn’t work if you are within the RETURN clause. It does, however, if you aren’t. For example: CREATE FUNCTION SchemaName.udfName ()RETURNS VARCHAR(50)ASBEGIN    RETURN    (            SELECT  t1.Field        FROM    SchemaName.Table1 t1        [...]

Sunday, January 18th, 2009

The Phantom Menace

How irritating. When I came home yesterday, my main workstation was simply dead. It appears that the power supply has just given up completely. For the last 14 months it has been running 24×7 without a single hiccup, but now its just ready for the trash bin. Tragic. Since a good power supply is one [...]