THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SELECT Hints, Tips, Tricks FROM Hugo Kornelis WHERE RDBMS = 'SQL Server'

How TOP wrecks performance (part 1)

This blog has moved! You can find this content at the following new location:

Published Thursday, November 6, 2014 5:51 PM by Hugo Kornelis

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



SWAT said:

How about with ties and Over & Partition by clause...

November 2, 2015 6:25 AM

Hugo Kornelis said:


WiTH TIES is covered above. OVER and PARTITION BY are, unfortunately, not supported for TOP - they would be a great addition to the options available in T-SQL and I know a lot of people have proposed this to Microsoft - but no luck (so far?)

November 2, 2015 9:28 AM

New Yeezy V2 said:

yeezy v 2の販売,환상 판매,La vendita Yeezy V2,Yeezy V2 de vente,En el mercado yeezy V2. Zebra Yeezy Yellow Yeezy Yeezysupply Yeezys Shoes Yeezys For Sale Yeezys Adidas Yeezys Yeezy Zebra Yeezy V2 Yeezy Supply Yeezy Sale Yeezy Price Yeezy Pirate Black Yeezy Outlet Yeezy For Sale Yeezy Cream Yeezy Boost V2 Yeezy Boost Yeezy Blue Tint Yeezy Blue Yeezy Beluga 2.0 Yeezy Beluga Yeezy Adidas Yeezy 350 V2 Yeezy 350 Boost V2 Yeezy 2018 Yeezy White Yeezys Where To Buy Yeezys Supreme Yeezy Real Yeezys New Yeezys New Yeezy V2 New Yeezy Cheap Yeezy Blue Tint Yeezy Black Yeezys Black Yeezy Beluga Yeezy Adidas Yeezys Adidas Yeezy V2 Adidas Yeezy Boost Adidas Yeezy Blue Tint Adidas Yeezy Adidas V2 Yeezy Zebra Yeezy Yellow Yeezy V2 Boost Yeezy V2 Yeezy Sales Yeezy V2 Sales Yeezy V2 Boost Yeezy V2 Yeezy Cream Yeezy Boost V2 Yeezy Boost 750 Yeezy Boost 700 Zebra Yeezys Zebra Yeezy Yellow Yeezy YeezySupply Yeezys Shoes Yeezys For Sale Yeezys UK Yeezys Yeezys V2 Zebra Yeezys Yellow Yeezy Yeezy Shoes White Yeezys Adidas Shoes For Men Adidas Shoes Yeezy For Sale Yeezy Cream Yeezy Boost 350 V2 Zebra Yeezy Boost 350 V2 Outlet Yeezy Boost 350 V2 Kaufen Yeezy Boost 350 V2 Footlocker Yeezy Boost 350 V2 Blue Tint Yeezy Boost 350 V2 Beluga Yeezy Boost 350 V2 Adidas Yeezy Boost 350 V2 Zebra Adidas Yeezy Boost 350 V2 Adidas Yeezy Boost 350 Adidas Yeezy Boost Yeezy For Sale Yeezy Cream Yeezy Blue Tint Yeezy Blue Yeezy Beluga 2.0 Yeezy Beluga Yeezy 750 Yeezy 700 Yeezy 500 Yeezy 350 V2 Yeezy 350 Boost V2 Yeezy 350 Boost Yeezy 350 Yeezy 2018 Yeezy White Yeezys White Yeezy Where To Buy Yeezys Ultra Boost Adidas Ultra Boost 4.0 Ultra Boost Supreme Yeezy Yeezy Yellow Yeezy V2 Boost Yeezy V2 Yeezy Sale New Yeezys New Yeezy V2 New Yeezy Uk Moncler Coat Uk Moncler Moncler Uk Online Moncler Uk Moncler Uk Outlet Moncler Uk Moncler Jacket Outlets Moncler Jacket Moncler Uk Jackets Moncler Jackets Goose Down Jackets Canada Goose Uk Nfl Jerseys Nfl Jersey Cheap Nfl Jersey Nfl Jersey Cheap Nfl Jersey Nfl Cheap Jerseys Cheap Nfl Jerseys Cheap Nfl Jersey Nhl Jerseys 2018 Nfl Jerseys For Sale Nfl Jerseys Cheap Nba Jerseys Cheap Nba Jerseys 2018 Nba Jerseys Cheap Jerseys Cheap Jersey 2018 Us Cheap China Jerseys Air Max 2018 2018 Nike Air Max 2018 Air Max Nike Vapormax Nike Air Vapor Max Vapormax Vapor Max Nike Vapor Max Vapormax 2018 Vapormax Vapor Max Nike Vapor Max 2018 Worldcup 2018 World Cup Soccer 2018 World Cup Russia 2018 World Cup Russia World Cup Football 2018 World Cup Football World Cup 2018 Warriors Jersey Nba Warriors Golden State Warriors Michael Kors Factory Sale Michael Kors bags Michael Kors Jordan Air Cheap Jordan Shoes Air Jordan Shoes Air Jordan Asics Shoes Asics Cheap Fitflop Fitflop Clearance Fitflop Sale Clearance Discount Fitflop Fitflop Outlet Fitflop Clearance Outlet Clearance Fitflop Cheap Pandora Charms Pandora Charms Sale Clearance Pandora Charms Wholesale Pandora Jewellery Pandora Wholesale Pandora Jewellery Wholesale Pandora Jewelry Pandora Outlet Pandora Charms Outlet Pandora Rings Pandora Bracelets Canada Goose Canada Goose UK Down Jackets For Women Canada Goose UK Jacket Canada Goose Jacket UK Canada Goose Jacket

June 29, 2018 3:43 PM

dongdong8 said:



July 23, 2018 11:38 PM

chenjinyan said:



August 22, 2018 11:27 PM said:"> Converse High Top,"> Air Max 90 EZ,"> nike blazer mid,"> Air VaporMax Plus,"> Air Max 90 Prm, nike free run shoes outlet,"> Converse 1970s,"> yeezy boost 500, Philippe Model Sale, converse shoes,"> nike blazer low,"> Nike Flyknit Racer,"> Philippe Model Women Sneakers, nike free run shoes,"> adidas Questar Boost, Nike LeBron 16,"> Nike Kyrie 4,"> Air Max 90 Essential, Converse Store,"> adidas Nmd Chukka, adidas shoes online, philippe model outlet online, air max 270 sale, adidas AW Run, adidas Yeezy Boost 350, nike free 4.0, Converse Seasonal Color,"> Nike Flyknit Chukka,"> yeezy boost 350,"> Air Max 90 VT, Converse Chuck Taylor High Top, adidas Yeezy Boost,"> Air Max 90 American Flag, Golden Goose Sneakers Sale, Nike Blazer Shoes,"> lunar flyknit htm nrg,"> Air VaporMax 95, Philippe Model,"> Air Max 90 Print, Nike LeBron 15,"> Air VaporMax 97, adidas Crazy Byw,"> flyknit lunar 2, adidas Ultra Boost, air max 95 shoes, Converse Shoes, Air VaporMax, Nike Air Max 90, adidas Nmd Human Race, Golden Goose V Star, air max 270 outlet, adidas Y3 Pure Boost, cheap adidas shoes, nike lunar shoes, Converse Monochrome, Yeezy Boost, Air Max 90 Kpu, nike free run womens, adidas Eqt Support, Golden Goose, converse outlet,"> yeezy powerphase calabasas,"> Nike LeBron 15, lunarglide 8, Air Max 90 Sneakerboot, Golden Goose Sneakers, adidas Yeezy Boost 350, adidas Yeezy Boost 550, philippe model sneakers outlet, nike fs lite, Air VaporMax Kpu TPU, adidas Energy Boost 3, adidas Yeezy Boost 350 V2, adidas Dame, adidas Yeezy Boost 700, nike free advantage, cheap air max 270, cheap nike flyknit shoes, Air Max 90 Mens, LeBron James Jerseys, Air Max 90 Shoes, Air Max 90 Womens, Philippe Model Men Sneakers, converse chuck taylor, Yeezy Boost Outlet, nike free run shoes sale, adidas Nmd Racer, Air Max 90 Sale, Air Max 90 QS, nike lunar shoes outlet, Converse Low Top, Cheap Air VaporMax Shoes, air max 95, Air Max 90 Ultra, adidas Dame 4, nike free 6.0, lunarglide 6, air max 95 sale, Converse Chuck Taylor Low Top, flyknit lunar 3, Converse Leather, Kyrie 4 On Sale, adidas Pure Boost, Air Max 90, Converse All Star Monochrome, adidas Yeezy Powerphase, Golden Goose May, Cheap Air Max 90 Shoes, nike air max 270, Philippe Model, Air Max 90 SP, philippe model on sale, adidas Nmd Xr4, adidas Nmd Runner, adidas Yeezy 500,"> yeezy boost 700, Air Max 90 Hyp, adidas Nmd R1, Air Max 90 Carved, Converse Chuck 70 Low Top, LeBron 16, flyknit lunar 1, Philippe Model Man, nike flyknit shoes sale, nike lunar womens, Air Max 90 Fireflies, Golden Goose Sale, nike free 5.0, Converse Chuck Taylor Leather, Nike Kyrie 4, nike free tr, converse all star, lunarglide 7, adidas shoes sale, Air Max 90 Zoom IT, adidas Yeezy Boost 750, LeBron 16 Shoes For Sale, cheap air max 95, nike free flyknit, air max 270, adidas Nmd Shoes,"> yeezy boost infant, Nike Air Max 95 Mens, adidas Iniki Runner Boost, adidas D Rose 8, Air Max 90 Mid, adidas Harden Vol 1, Nike Air VaporMax Shoes, Yeezy Boost Sale, Converse All Star Seasonal Color, Nike LeBron 16, nike flyknit shoes outlet, adidas Alphabounce, adidas Yeezy Boost 650, yeezy boost 350, adidas Yeezy Boost 350 V2, lunar 2016, adidas Tubular Doom Sock, Air VaporMax CS, Kyrie 4, Philippe Model Shoes, air max 95 outlet, adidas Climacool Shoes, yeezy boost 350 v2, nike flyknit shoes, adidas Iniki Runner Boost, adidas Harden Vol 2, Philippe Model Mens, philippe model outlet, nike free run mens, Converse Chuck 70 High Top, adidas Yeezy Boost 330, adidas shoes, nike air max 95, adidas I5923, Golden Goose Slide, yeezy boost 350 v2, Nike Blazer Shoes Sale, yeezy boost, nike air max 270, Air VaporMax Moc, Air VaporMax Flyknit, lunarglide 5, Nike LeBron 16 Shoes, adidas yeezy boost, Nike Blazer Outlet, Philippe Model Sneakers, Golden Goose Mid Star, adidas Yeezy Boost 750, Golden Goose Ball Star, Air Max 90 Flyknit, Converse Outlet, Air VaporMax Running, adidas Yung 1, Philippe Model Woman, Air VaporMax Outlet, lunar flyknit chukka, adidas shoes outlet, Air Max 90 Lthr, adidas Prophere, Yeezy Boost Shoes, Nike Kyrie 3, Air Max 90 Kjcrd Ice Qs, lunarepic flyknit, Air Max 90 BR, Golden Goose Francy, adidas Nmd R2, Philippe Model Sneakers Sale, Air VaporMax 20, adidas Nmd Xr1, Philippe Model Womens, adidas Arkyn Boost, Kyrie 4 Shoes For Sale, nike lunar on sale, adidas Yeezy Boost 700, adidas Pure Boost Dpr, adidas Climachill Boost, nike blazer high, Philippe Model Sneakers Outlet, Air Max 90 Glow, nike free rn, nike lunar mens, Golden Goose Starter, Golden Goose Super Star, Nike Flyknit Trainer, Air VaporMax Sale, adidas Crazy Explosive, Kyrie 4 Shoes, Philippe Model Sneakers, lunarglide 4, Cheap Nike Blazer Shoes, Nike Air Max 95 Womens, Air Max 90 Outlet, adidas Nmd City Sock 2 Pk, adidas Eqt Shoes, Air Max 90 Jcrd, adidas Ultra Boost

April 3, 2019 2:19 AM

yanmaneee said:">">

June 29, 2020 10:53 PM

Leave a Comment


About Hugo Kornelis

Hugo is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server. In his spare time, Hugo likes to visit the SQL Server newsgroups, in order to share and enhance his knowledge of SQL Server.
Privacy Statement