Race to post 1,000,000
-
We are getting closer to the magic number....
-SQLBill
-
Yes - we are.
Maybe everybody should retire early when we get to 999999.
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 -
Less than 5000 to go now!
Hope this helps,
Rich[p]
[/p] -
Things seem to have slowed down a bit on the forums - or is it just perception?
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 -
CirquedeSQLeil (9/29/2010)
Things seem to have slowed down a bit on the forums - or is it just perception?Agreed. Certainly fewer posts that I can answer.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
It's been a quiet week. There are lulls and quick expansions in the forums at times.
-
Where do you see the total number of posts?
-
Daniel Bowlin (9/29/2010)
Where do you see the total number of posts?Look a couple lines under your name and you'll see this :
Post #995597
-
Each post has the ID counter for it under it to the left.
Getting close to a million after 9 years.
-
Steve Jones - Editor (9/29/2010)
Each post has the ID counter for it under it to the left.Getting close to a million after 9 years.
Wow, so much content and yet that's barely 304 posts / day over 9 years. :w00t:
-
Ninja's_RGR'us (9/29/2010)
Steve Jones - Editor (9/29/2010)
Each post has the ID counter for it under it to the left.Getting close to a million after 9 years.
Wow, so much content and yet that's barely 304 posts / day over 9 years. :w00t:
That's still not too shabby. Consider that most of those posts are not from the heavy hitters / frequent posters.
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 -
I'm betting the average has increased dramatically over the years. Might be interesting to see an avg posts/day for each of those 9 years.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Ninja's_RGR'us (9/29/2010)
Daniel Bowlin (9/29/2010)
Where do you see the total number of posts?Look a couple lines under your name and you'll see this :
Post #995597
I must have looked past this a bunch of times. Thanks.
-
Wow, it's amazing that we are actually rapidly approaching the 1,000,000th post. Now, question is, what data type is the Post number??? 😉 (in other words, when will we hit the max value ? THAT could be funny - "cannot post message; dataoverflow on line 7" or something like that):hehe:
-
Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those, and it seems pretty unlikely it's a non-integer datatype, so the smallest max value it could have is INT at 2,147,483,647--if it's taken more than ten years to hit a million that suggests there isn't likely to be a problem for another twenty thousand years or so. 😛
Viewing 15 posts - 31 through 45 (of 129 total)
You must be logged in to reply to this topic. Login to reply