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
<< Don't Let Output Dictate your Database Design | Home | SQL Server 2005: CROSS APPLY >>

Slightly more dynamic ORDER BY in SQL Server 2005

There's a very interesting way of handling complicated, multi-column dynamic sorts over at john-sheenan.com.

I am not sure about the efficiency of this approach, but in general dynamic sorting tends not to be very efficient anyway (unless you use dynamically-created SQL statements).  Overall, it is a very clever use of RANK() and definitely worth a look.

Thanks for the great idea, John!

Print | posted on Tuesday, June 05, 2007 10:24 AM | Filed Under [ Techniques Links ]

Feedback

Gravatar

# re: Slightly more dynamic ORDER BY in SQL Server 2005

Hey Jeff, thanks for the link. I originally developed this method for use with pretty small result sets (<100 rows) and I haven't had an performance issues. I haven't done any testing with bigger sets, but I'm pretty sure it won't scale. I'm not good enough with perf testing though to run any comparison tests.
6/6/2007 9:46 AM | John S.
Gravatar

# re: Slightly more dynamic ORDER BY in SQL Server 2005

Could one just use dynamic sql?
4/1/2010 5:33 PM | Shane
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET

Copyright © Jeff Smith