Bryan Tsai: Comments http://www.bryantsai.com I need to think ... Wed, 19 Nov 2008 00:52:19 +0800 Mon, 11 Jun 2007 00:32:12 +0800 http://wordpress.org/?v=2.3.3 60 653315http://www.feedburner.com Comment on Advanced SQL - Selecting Rows with Max Value from Groups by Anonymous http://feeds.feedburner.com/~r/bryantsai/comments/~3/125846999/advanced-sql-selecting-rows-with-max-value-from-groups.html Anonymous Mon, 11 Jun 2007 00:32:12 +0800 http://www.bryantsai.com/archives/advanced-sql-selecting-rows-with-max-value-from-groups.html#comment-13 You can rewrite it using related subquery:

SELECT department, name, salary FROM DEPARTMENT dept
WHERE salary=
(SELECT max(salary) FROM DEPARTMENT WHERE department=dept.department)

But I am not sure if it performs better than yours.

]]> http://www.bryantsai.com/archives/advanced-sql-selecting-rows-with-max-value-from-groups.html#comment-13 Comment on My Favorite List of Firefox Extension by lyynn http://feeds.feedburner.com/~r/bryantsai/comments/~3/77611515/my-favorite-list-of-firefox-extension.html lyynn Fri, 06 Jan 2006 14:56:51 +0800 http://www.bryantsai.com/archives/my-favorite-list-of-firefox-extension.html#comment-4 Good.Thank U 8-))

]]> http://www.bryantsai.com/archives/my-favorite-list-of-firefox-extension.html#comment-4 Comment on Cruisecontrol 2.3 Released by bryan http://feeds.feedburner.com/~r/bryantsai/comments/~3/77611516/cruisecontrol-23-released.html bryan Mon, 03 Oct 2005 09:22:15 +0800 http://www.bryantsai.com/archives/cruisecontrol-23-released.html#comment-5 The problem I encountered with Subversion modification set in CruiseControl is because I set the following attribute to the modificationset element: requiremodification=”yes”. I guess since version 2.2.1 they have changed it to be only allowing “true/false”. It’s weird that I didn’t even notice this. Probably there wasn’t obvious indication of that in the log.

Frustrating but anyway, I found the problem ...

]]> http://www.bryantsai.com/archives/cruisecontrol-23-released.html#comment-5 Comment on Google beyond web by bryan http://feeds.feedburner.com/~r/bryantsai/comments/~3/77611517/google-beyond-web.html bryan Tue, 07 Dec 2004 10:24:53 +0800 http://www.bryantsai.com/archives/google-beyond-web.html#comment-3 Yes, current version of Google Desktop Search does not support PDF (really sad), nor does it support target folder customization (though you still can customize which folders not to be indexed). But I believe Google surely will provide such functions in subsequent releases. All in all, this tool is free, lean, and fast (compared to other tools). I couldn’t find a suitable indexing tool before, so I am pretty happy that finally I could have one now (nearly suits to my needs).

]]> http://www.bryantsai.com/archives/google-beyond-web.html#comment-3 Comment on Google beyond web by howy http://feeds.feedburner.com/~r/bryantsai/comments/~3/77611518/google-beyond-web.html howy Thu, 25 Nov 2004 11:04:09 +0800 http://www.bryantsai.com/archives/google-beyond-web.html#comment-2 HIHI , i have few comments regarding this tool
1. It can’t sepcify a target folder for searching
2. it can’t recognize pdf format
3. Does this tool consume CPU a lot?

My name is HOWY

]]> http://www.bryantsai.com/archives/google-beyond-web.html#comment-2