More with SQL Server 2005 : Top n Per Group, Paging, and Common Table Expressions
30 Mar 2007 1:21pm GMT I wrote about a few of the new features in SQL 2005 and how they can be used to solve some old "classic" SQL problems very easily, and I thought I'd briefly discuss a few more. Also, if you enjoy baseball, read on! read more...
SQL Server 2005: Using PARTITION and RANK in your criteria
28 Mar 2007 6:18pm GMT The RANK and PARTITION features in 2005 are simply amazing. They make so many "classic" SQL problems very easy to solve. read more...
Two Words: Baseball
14 May 2004 2:28am GMT It's baseball season again and as many SQLTeamer's have probably discovered over the years, I'm a huge fan of the game. Living in Boston, of course my team of preference is the Red Sox which in itself can be quite a rollercoster ride.