THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
Please Vote: Windowing Enhancements in SQL Server
Back in January 2007, SQL guru Itzik Ben-Gan posted a series of MS Connect enhancement requests concerning windowing function enhancements. Those who have used the ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE() functions on SQL 2005 and 2008, you already know how useful they are. They simplify code and can improve performance ...
Michael Coles: Sergeant SQL
November 19, 2009
Demos From Cape Cod .NET: T-SQL Power! Presentation
On Tuesday night I was honored to present a new talk to the Cape Cod .NET Users Group that meets in Plymouth, MA. The talk is called ''T-SQL Power! Learning to Harness the Under-Used OVER Clause''. Following is the abstract for the talk:First introduced in SQL Server 2005, the OVER clause is an ANSI SQL enhancement that gives you tremendous ...
June 18, 2009
Brought to you by