Jeff's SQL Server Blog

UNPIVOT: Normalizing data on the fly

posted @ Wednesday, April 23, 2008 10:33 AM | Feedback (12)

Top N Percent per Group

posted @ Thursday, February 21, 2008 1:05 PM | Feedback (4)

Implementing Table Inheritance with SQL Server

posted @ Thursday, February 21, 2008 11:05 AM | Feedback (3)

Date Only and Time Only data types in SQL Server 2005 (without the CLR)

posted @ Wednesday, October 31, 2007 9:13 AM | Feedback (8)

Taking a look at CROSS APPLY

posted @ Thursday, October 18, 2007 5:01 PM | Feedback (5)

SQL 2005 PIVOT Operator (link)

There's two interesting posts over at the MSDN blogs from Craig Freedman about the new PIVOT operator in SQL 2005. First, he gives a nice overview of the operator and how to use it, and then he follows it up with a performance analysis as well. A good read, check it out.

posted @ Thursday, July 12, 2007 9:24 AM | Feedback (2)

SQL Server 2005: CROSS APPLY

SQL Server User-Defined Functions (UDFs) can return either a single value or virtual tables. However, sometimes we might like for a User-Defined Function to simply return more than 1 piece of information, but an entire table is more than what we need.

posted @ Tuesday, June 12, 2007 8:52 AM | Feedback (1)

SQL Server 2005: Specifying Partitions for Aggregate Functions

Did you know that a new feature in SQL Server 2005 allows you to specify an OVER partition for aggregate functions in your SELECT statements?

read more...

posted @ Monday, May 21, 2007 2:52 PM | Feedback (7)

SQL Server 2005: Using EXCEPT and INTERSECT to compare tables

Previously, I had written that UNION ALL (combined with a GROUP BY) is a really quick and easy way to compare two tables. Well, now in SQL 2005, we have another option: using EXCEPT and INTERSECT. And these are even easier!

read more...

posted @ Wednesday, May 02, 2007 2:47 PM | Feedback (7)

Regular Expression Replace in SQL 2005 (via the CLR)

I had to do some data clean up the other day, and really needed some regular expression replacements to do the job. Since .NET has a great RegularExpressions namespace, and since SQL 2005 allows you to integrate .NET CLR functions in your T-SQL code, I thought I'd go ahead and experiment with creating a RegExReplace() function.

read more...

posted @ Friday, April 27, 2007 4:20 PM | Feedback (5)

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 (21)

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 (10)

Lots of great SQL Server 2005 Express Downloads

Have you visited the SQL Server 2005 Express Downloads page lately?

read more...

posted @ Thursday, April 27, 2006 10:07 AM | Feedback (1)

Some Simple SQL Rules to Live By

Most of these are really basic. Some are my take on established ideas and standards, and may be controversial. Agree or disagree? All feedback is welcome! (well ... mostly the "I agree, you're a genius" feedback is welcome ... but I'll accept all of it, I suppose)

read more...

posted @ Tuesday, March 14, 2006 12:42 PM | Feedback (29)