How many peers?
-
Comments posted to this topic are about the item How many peers?
-
This was removed by the editor as SPAM
-
I make 92m. Bigint 2^63-1 (9,223,372,036,854,775,807) / 100,000,000 = 92,233,720.36854775.
How do we get 92billion? Am I missing something?
-
Ok so don't use windows calculator to try to calculate this. I can now see my mistake.
Good question, poor calculator skills.
-
Good question, thanks
...
-
Too many zeros!
The referenced post about running out of bigints is interesting - a comment to that post suggests it's possible in some environments - I want to try that!
-
I got it right by pure luck. I haven't yet had my first cup of coffee so I was too lazy to do the math. I was really hoping for the "more than you would ever possibly need" answer but after a short perusing of the options it wasn't there.
Good question Steve._______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
TimCarrett (3/4/2016)
Ok so don't use windows calculator to try to calculate this. I can now see my mistake.Good question, poor calculator skills.
Hey, I used the Windows calculator. The beep indicated that something went wrong and I found I was missing 3 digits, so I just missed 3 digits from the range.
I had the advantage of having my coffee first.
-
TimCarrett (3/4/2016)
Ok so don't use windows calculator to try to calculate this. I can now see my mistake.Good question, poor calculator skills.
Worked OK for me after switching to View / Scientific
-
Total guess, but got the point!
-
Why not start it at max negative and use the negative side as well? Then you would have almost twice as many...
-
TimCarrett (3/4/2016)
Ok so don't use windows calculator to try to calculate this. I can now see my mistake.Good question, poor calculator skills.
I think I did that a few times writing this question.
-
paul s-306273 (3/4/2016)
Total guess, but got the point!Good. That was the intention
-
emiddlebrooks (3/4/2016)
Why not start it at max negative and use the negative side as well? Then you would have almost twice as many...You could do that, and some do. I find negative numbers problematic for humans when working with data and joins for troubleshooting or other work.
My point was with a BIGINT, I'm not sure you need to do this.
-
Steve Jones - SSC Editor (3/4/2016)
paul s-306273 (3/4/2016)
Total guess, but got the point!Good. That was the intention
... even better then.
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply