Tag Archives: sql server

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. … Continue reading →

SQL Express is the free, low-powered MySQL-competing version of SQL Server. It’s primarily neutered when it comes to hardware utilization (it will use at most 1 CPU and 1GB memory) and maximum database size (4GB excluding log files), but for … Continue reading →