Home Forums SQL Server 2008 SQL Server Newbies ORDER BY in a view RE: ORDER BY in a view

  • July 14, 2014 at 4:21 pm

    #1729301

    ...I know that TOP ### in order to support ORDER BY is a kludge, that might disappear in a future release.

    I think I know what Post you are talking about.

    TOP 100 PERCENT is not a kludge nor is TOP <really big number>. The TOP clause is supported through SQL Server 2014 and does not look like it's going to be depreciated anytime soon. Microsoft usually warns you when a feature is going to be depreciated.

    TOP is pretty major and affects query processing; stuff like that is not depreciated very often. Take a look at this query processing order pdf:

    Logic Query Processing. The stuff you see here is likely not going away for a long, long time (e.g. SELECT, APPLY, JOIN, GROUP BY, WHERE, HAVING, DISTINCT, TOP, SELECT, ETC...)

    They kind of stuff that gets depreciated looks more like this. This is purely opinion based on my observations.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001