March 4, 2016 at 11:33 am
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...
Almost twice as many?
My math says that if you include negatives and zero, you'll get twice as many plus two.
March 4, 2016 at 12:11 pm
sknox (3/4/2016)
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...Almost twice as many?
My math says that if you include negatives and zero, you'll get twice as many plus two.
Wouldn't that count as almost? It is within two. 😛
_______________________________________________________________
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/
March 4, 2016 at 12:36 pm
Andy Warren (3/4/2016)
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!
More than trying to run out of bigints, I want to try an environment with 92 billion replication peers.
Just because it is possible doesn't make it a goal type of thing. It would be an interesting project.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 6, 2016 at 7:28 pm
SQLRNNR (3/4/2016)
Andy Warren (3/4/2016)
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!
More than trying to run out of bigints, I want to try an environment with 92 billion replication peers.
Just because it is possible doesn't make it a goal type of thing. It would be an interesting project.
If either of you try anything over 1000 hosts, I'd like to know. Or get an article.
March 7, 2016 at 5:14 am
deleted - somehow got posted twice.
Tom
March 7, 2016 at 7:22 am
Interesting question. I decided to treat it as simple arithmetic (what's pproximately 2**63 /10**9) so I got it "right".
But is it really right? Are there perhaps system limuts somewhere that restrict it to a lot less that 92 billion? since a distribution database identifies a subscriber with a tinyint identifier, we would need a five level cascade of distributors with 370 million distribution databases at leaf level of the cascade - I'm not convinced that SQL Server could handle that!
The article referenced that suggests running out of bigints is not somethig that can happen was rather naive even in 2011, as pointed out in Beckman's comment on it. It's decades since scientific computing started handling more than 100,000 items of data per second, that estimate of maximum rate is several decimal orders of magnitude out. One of my friends is a professor (now emeritus) of physics at UoM's Jodrell Bank observatory and I know they were processing more data items per second than that by 1990 or earlier because we several times discussed various aspects (including data rates) of the system (which didn't use SQL but a home-rolled data storage system written mostly in Forth).
Tom
March 10, 2016 at 4:39 pm
Thanks for the question.
March 11, 2016 at 12:42 am
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply