Saturday, May 12, 2012

High Scalability Blog

The High Scalability blog is on large data web applications. A very good site!

Monday, May 7, 2012

Astronomy surveys

SKA
LSST
Pan-STARRS
Sloan
2MASS: Wiki: 2MASS, The Two Micron All Sky Survey at IPAC
Wise: wise

Wednesday, May 2, 2012

Use TOP and DISTINCT together in t-sql

Surprisingly it is difficult to use TOP and DISTINCT together in SQL. This will not work: select top 2 distinct t.ID as tID, t.Name as tName from Table1 order by tID It can be replaced by something like this to work: select top 2 * from (select distinct t.ID as tID, t.Name as tName from Table1 t) y order by tID Also see some other web links, such as Here

Friday, April 20, 2012

Blog Archive

Followers