Programmer Articles

My interview experience with Google
http://www.philosophicalgeek.com/2007/08/12/my-interview-experience-with-google/

Finding Great Developers

http://www.joelonsoftware.com/articles/FindingGreatDevelopers.html

Error Handling in SQL 2000 – a Background

http://www.sommarskog.se/error-handling-I.html

http://sharedderrick.blogspot.com/2010/04/sql-servererror-log-file.html

Custom Date and Time Format Strings

Read the following article for asp.net custom date and time format:

http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

SQL Server Date Formats

Here is a table for SQL Server Date Format:

http://www.sql-server-helper.com/tips/date-formats.aspx

多db record 處理情況

今日試左兩個好多record 既database table，基本上一join 就會load 太長時間timeout

同埋用左好多以前無寫既野，好似

1. declare variable

2. temp table

@tmptable, @@tmptable, #tmptable 既分別

http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html

How to add sequence number within groups of repeating values

Read this:

http://www.tek-tips.com/viewthread.cfm?qid=859372