How many peers?

Question

Post reply

How many peers?

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
March 3, 2016 at 8:28 pm

#324663

Comments posted to this topic are about the item How many peers?
March 3, 2016 at 10:22 pm

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 22 total)

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

TimCarrett Default port Points: 1484 More actions · Answer 1

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?

TimCarrett Default port Points: 1484 More actions · Answer 2

Ok so don't use windows calculator to try to calculate this. I can now see my mistake.

Good question, poor calculator skills.

HappyGeek SSCoach Points: 18729 More actions · Answer 3

HappyGeek

SSCoach

Points: 18729

March 4, 2016 at 2:48 am

#1863024

Good question, thanks

...

Andy Warren SSC Guru Points: 119902 More actions · Answer 4

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!

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

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/

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

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. 😀

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

timwell SSCertifiable Points: 5315 More actions · Answer 7

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

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

paul s-306273

SSChampion

Points: 10730

March 4, 2016 at 8:12 am

#1863139

Total guess, but got the point!

emiddlebrooks Hall of Fame Points: 3394 More actions · Answer 9

Why not start it at max negative and use the negative side as well? Then you would have almost twice as many...

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 10

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.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 11

paul s-306273 (3/4/2016)
Total guess, but got the point!

Good. That was the intention

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 12

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.

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

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.