Unanswered: The significance of "1024" in SQL Server?
Sorry for the basic question but what is the significance of 1024? Is this true in Oracle as well? Is it a Fibonacci number?(just kidding). But why is the limit 1024 as far as fields in a table or 1024 arguements in a stored procedure, etc? Thanks in advance for adding to the "nuts and bolts" of my knowledge.
"In binary notation, 1024 is represented as 10000000000, making it a simple "round number" occurring frequently in computer applications."
That sounds bogus to me. Because in binary, 2 is also a round number (10), as is 4 (100), 8 (1000), 512 (1000000000), and 2048 (100000000000), etc....so it still begs the question "Why 1024 and not 512 or 2048?", which Jezemine has so elegantly answered.
If it's not practically useful, then it's practically useless.