This question - Power of 2 and performance in SQL Server - is this a "good" question by the standards of this site? Sure, it's an advanced optimisation programming technique. But my first response was "so what"? Either my application needs to divide by 255 or it needs to divide by 256. It's not like I'm not going to use SQL Server for that one query in my applicaiton and install a customised MariaDB instance to save a few nanoseconds.
I thought about flagging it. "It should be closed for another reason" was the only option which made sense. "Too broad" it diametrically opposite to what it is and nothing under "off topic" matched my concerns.
It is interesting, but its not "practical, answerable questions based on actual problems that you face" IMHO. Guidance, please?