Order By Limitations and Restrictions

Question

Post reply

Order By Limitations and Restrictions

Junior Galvão - MVP

SSCertifiable

Points: 6951
More actions
May 13, 2017 at 11:21 am

#330235

Comments posted to this topic are about the item Order By Limitations and Restrictions

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 1

Actually the limitation of the columns in ORDER BY is 8060, in the case when all columns would be byte-size 1 Byte 😉

Igor Micev,My blog: www.igormicev.com

Stewart "Arturius" Campbell SSC Guru Points: 72634 More actions · Answer 2

Nice back-to-basics question,thanks Junior

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

paul s-306273 SSChampion Points: 10730 More actions · Answer 3

paul s-306273

SSChampion

Points: 10730

May 15, 2017 at 2:06 am

#1942479

Never been anywhere near this limit.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 4

Igor Micev - Saturday, May 13, 2017 11:23 AM
Actually the limitation of the columns in ORDER BY is 8060, in the case when all columns would be byte-size 1 Byte 😉

What if we're using bit columns?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Nice one to start the week with - thanks, Junior!

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

Luis Cazares - Monday, May 15, 2017 6:18 AM
Igor Micev - Saturday, May 13, 2017 11:23 AM
Actually the limitation of the columns in ORDER BY is 8060, in the case when all columns would be byte-size 1 Byte 😉
What if we're using bit columns?

Heh - I think a redesign would be in order. 😉

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions