Junior Galvão - MVP
May 13, 2017 at 11:21 am
Comments posted to this topic are about the item Order By Limitations and Restrictions
May 13, 2017 at 11:23 am
Igor Micev,My blog: www.igormicev.com
Stewart "Arturius" Campbell
May 14, 2017 at 2:52 am
Nice back-to-basics question,thanks Junior
____________________________________________Space, the final frontier? not any more...All limits henceforth are self-imposed.“libera tute vulgaris ex”
May 15, 2017 at 2:06 am
Never been anywhere near this limit.
May 15, 2017 at 6:18 am
Igor Micev - Saturday, May 13, 2017 11:23 AMActually 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?
May 15, 2017 at 8:10 am
Nice one to start the week with - thanks, Junior!
May 16, 2017 at 11:10 am
Luis Cazares - Monday, May 15, 2017 6:18 AMIgor Micev - Saturday, May 13, 2017 11:23 AMActually 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 PersonifiedString Splitting with True PerformanceBest practices on how to ask questions
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply