Jeff's SQL Server Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server
posts - 157, comments - 2686, trackbacks - 64

My Links

Advertisement

News

Welcome to my weblog. My name is Jeff Smith, I am software developer in Boston, MA and I was recently named a 2009 SQL Server MVP. Check in frequently for tips, tricks, commentary and ideas on SQL Server and .NET programming.


Subscribe





Archives

Post Categories

Programming

Sports

SQL

Sports

Why not? Sports and databases go hand in hand, baseball in particular. We can do some baseball analysis, answer some questions and have some fun -- all while using SQL the whole time.
More with SQL Server 2005 : Top n Per Group, Paging, and Common Table Expressions

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...

posted @ Friday, March 30, 2007 9:21 AM | Feedback (31) | Filed Under [ T-SQL Sports Paging Data SQL Server 2005 ]

SQL Server 2005: Using PARTITION and RANK in your criteria

The RANK and PARTITION features in 2005 are simply amazing. They make so many "classic" SQL problems very easy to solve.

read more...

posted @ Wednesday, March 28, 2007 2:18 PM | Feedback (34) | Filed Under [ T-SQL Sports SQL Server 2005 ]

Two Words: Baseball

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.

posted @ Thursday, May 13, 2004 10:28 PM | Feedback (8) | Filed Under [ Sports ]

Powered by:
Powered By Subtext Powered By ASP.NET