Jeff Moden (4/12/2009)
ORDER BY on unindexed Tally table, for starters. All the other comments about large table variables may apply, as well, although I haven't tested the code, yet.
Unindexed? :unsure:
Flo's code:
DECLARE @tally TABLE (N INT NOT NULL, PRIMARY KEY CLUSTERED (N))
edit: overlapped with Jeff's latest 🙂
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi