January 20, 2016 at 1:23 pm
FYI, Amazon has crystal balls for a decent price, if anybody needs one. 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 20, 2016 at 1:36 pm
Alan.B (1/20/2016)
Eirikur Eiriksson (1/20/2016)
Alvin Ramard (1/20/2016)
Ed Wagner (1/20/2016)
Steve Jones - SSC Editor (1/20/2016)
This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length. We were, by far, the largest user of this forum software, and larger than any other .NET forums I've seen.And yet, the site still works. Sure, it has the quote bug and a glitch or slowdown from time to time, but just look at it. I'd say it's a job well done.
Tell me The Thread's award is not that it's going to be killed off. I've come to enjoy it. It's a lot like a pressure release valve that releases pressure slowly to prevent explosions. I know I don't want to explode. 😉
Look at all the cool things to come out of The Thread. There's the Pork Chop Launcher (plus variants), DBCC TIMEWARP and the Hippo Guarding the Tent in the Dessert.
Cool things? I wonder how many other threads keep referring to crystal balls and silver spoons? 😎
DBCC COUNT_SPOONS
😎
DBCC COUNT_SPOONS returns a 0 on my system.
A common misconception is that the return value is an integer, it isn't, it's a 64 floating point number, fully IEEE 754 compliant, the values you would be looking for are between the 48th and 52nd bits of the fraction section, IEEE recognizes that no one will hold greater supplies of spoons than this counts for.
😎
January 20, 2016 at 1:38 pm
GilaMonster (1/20/2016)
Eirikur Eiriksson (1/20/2016)
Alvin Ramard (1/20/2016)
Ed Wagner (1/20/2016)
Steve Jones - SSC Editor (1/20/2016)
This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length. We were, by far, the largest user of this forum software, and larger than any other .NET forums I've seen.And yet, the site still works. Sure, it has the quote bug and a glitch or slowdown from time to time, but just look at it. I'd say it's a job well done.
Tell me The Thread's award is not that it's going to be killed off. I've come to enjoy it. It's a lot like a pressure release valve that releases pressure slowly to prevent explosions. I know I don't want to explode. 😉
Look at all the cool things to come out of The Thread. There's the Pork Chop Launcher (plus variants), DBCC TIMEWARP and the Hippo Guarding the Tent in the Dessert.
Cool things? I wonder how many other threads keep referring to crystal balls and silver spoons? 😎
DBCC COUNT_SPOONS
😎
Returns 0, no matter when it's run or with what parameters.
IIRC there is a Connect for this one
😎
January 20, 2016 at 1:58 pm
Phil Parkin (1/20/2016)
Eirikur Eiriksson (1/20/2016)
Grant Fritchey (1/20/2016)
Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It evidently looks like "an exponentially growing log file."All I can say is...
WELL DONE!
Keep it up. Good job everyone.
At 1.273 Kb a post that is not very efficient, you should hire a proper performance and optimization consultants:-D
😎
65 milli-bits is actually extremely small and sits somewhere in the realms of quantum storage.
An average of a post
😎
BLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLA Homework BLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLA Why? BLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLA help mee!!! BLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLA What? BLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLA Not listening BLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLA Cat BLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLABLA
Any compression algorithm would do a good job on this, even PKZIP manages this below 320 bytes. That would bring the Thread down to a tweet or 15.67 Mb.
😎
January 20, 2016 at 1:59 pm
Lynn Pettis (1/20/2016)
Brandie Tarvin (1/20/2016)
Eirikur Eiriksson (1/20/2016)
Alvin Ramard (1/20/2016)
Ed Wagner (1/20/2016)
Steve Jones - SSC Editor (1/20/2016)
This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length. We were, by far, the largest user of this forum software, and larger than any other .NET forums I've seen.And yet, the site still works. Sure, it has the quote bug and a glitch or slowdown from time to time, but just look at it. I'd say it's a job well done.
Tell me The Thread's award is not that it's going to be killed off. I've come to enjoy it. It's a lot like a pressure release valve that releases pressure slowly to prevent explosions. I know I don't want to explode. 😉
Look at all the cool things to come out of The Thread. There's the Pork Chop Launcher (plus variants), DBCC TIMEWARP and the Hippo Guarding the Tent in the Dessert.
Cool things? I wonder how many other threads keep referring to crystal balls and silver spoons? 😎
DBCC COUNT_SPOONS
😎
Officially added to our list.
Does that mean there should also be a DBCC COUNT_BALLS?
For some that could potentially be some hard math
😎
January 20, 2016 at 5:07 pm
Eirikur Eiriksson (1/20/2016)
Alan.B (1/20/2016)
Eirikur Eiriksson (1/20/2016)
Alvin Ramard (1/20/2016)
Ed Wagner (1/20/2016)
Steve Jones - SSC Editor (1/20/2016)
This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length. We were, by far, the largest user of this forum software, and larger than any other .NET forums I've seen.And yet, the site still works. Sure, it has the quote bug and a glitch or slowdown from time to time, but just look at it. I'd say it's a job well done.
Tell me The Thread's award is not that it's going to be killed off. I've come to enjoy it. It's a lot like a pressure release valve that releases pressure slowly to prevent explosions. I know I don't want to explode. 😉
Look at all the cool things to come out of The Thread. There's the Pork Chop Launcher (plus variants), DBCC TIMEWARP and the Hippo Guarding the Tent in the Dessert.
Cool things? I wonder how many other threads keep referring to crystal balls and silver spoons? 😎
DBCC COUNT_SPOONS
😎
DBCC COUNT_SPOONS returns a 0 on my system.
A common misconception is that the return value is an integer, it isn't, it's a 64 floating point number, fully IEEE 754 compliant, the values you would be looking for are between the 48th and 52nd bits of the fraction section, IEEE recognizes that no one will hold greater supplies of spoons than this counts for.
😎
Everyone knows that.
-- Itzik Ben-Gan 2001
January 20, 2016 at 6:45 pm
Alan.B (1/20/2016)
Eirikur Eiriksson (1/20/2016)
Alvin Ramard (1/20/2016)
Ed Wagner (1/20/2016)
Steve Jones - SSC Editor (1/20/2016)
This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length. We were, by far, the largest user of this forum software, and larger than any other .NET forums I've seen.And yet, the site still works. Sure, it has the quote bug and a glitch or slowdown from time to time, but just look at it. I'd say it's a job well done.
Tell me The Thread's award is not that it's going to be killed off. I've come to enjoy it. It's a lot like a pressure release valve that releases pressure slowly to prevent explosions. I know I don't want to explode. 😉
Look at all the cool things to come out of The Thread. There's the Pork Chop Launcher (plus variants), DBCC TIMEWARP and the Hippo Guarding the Tent in the Dessert.
Cool things? I wonder how many other threads keep referring to crystal balls and silver spoons? 😎
DBCC COUNT_SPOONS
😎
DBCC COUNT_SPOONS returns a 0 on my system.
It's actually
DBCC SilverSpoons(Count)
Other options include
Max
Redundant
HaventLearnedYet
Imposter
Feed
Capacity (similar to logspace but used for brain cavity space)
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
January 20, 2016 at 7:10 pm
SQLRNNR (1/20/2016)
Alan.B (1/20/2016)
Eirikur Eiriksson (1/20/2016)
Alvin Ramard (1/20/2016)
Ed Wagner (1/20/2016)
Steve Jones - SSC Editor (1/20/2016)
This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length. We were, by far, the largest user of this forum software, and larger than any other .NET forums I've seen.And yet, the site still works. Sure, it has the quote bug and a glitch or slowdown from time to time, but just look at it. I'd say it's a job well done.
Tell me The Thread's award is not that it's going to be killed off. I've come to enjoy it. It's a lot like a pressure release valve that releases pressure slowly to prevent explosions. I know I don't want to explode. 😉
Look at all the cool things to come out of The Thread. There's the Pork Chop Launcher (plus variants), DBCC TIMEWARP and the Hippo Guarding the Tent in the Dessert.
Cool things? I wonder how many other threads keep referring to crystal balls and silver spoons? 😎
DBCC COUNT_SPOONS
😎
DBCC COUNT_SPOONS returns a 0 on my system.
It's actually
DBCC SilverSpoons(Count)
Other options include
Max
Redundant
HaventLearnedYet
Imposter
Feed
Capacity (similar to logspace but used for brain cavity space)
Watch your data types on those. Some of them can overflow a bigint.
January 20, 2016 at 7:23 pm
Ed Wagner (1/20/2016)
SQLRNNR (1/20/2016)
Alan.B (1/20/2016)
Eirikur Eiriksson (1/20/2016)
Alvin Ramard (1/20/2016)
Ed Wagner (1/20/2016)
Steve Jones - SSC Editor (1/20/2016)
This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length. We were, by far, the largest user of this forum software, and larger than any other .NET forums I've seen.And yet, the site still works. Sure, it has the quote bug and a glitch or slowdown from time to time, but just look at it. I'd say it's a job well done.
Tell me The Thread's award is not that it's going to be killed off. I've come to enjoy it. It's a lot like a pressure release valve that releases pressure slowly to prevent explosions. I know I don't want to explode. 😉
Look at all the cool things to come out of The Thread. There's the Pork Chop Launcher (plus variants), DBCC TIMEWARP and the Hippo Guarding the Tent in the Dessert.
Cool things? I wonder how many other threads keep referring to crystal balls and silver spoons? 😎
DBCC COUNT_SPOONS
😎
DBCC COUNT_SPOONS returns a 0 on my system.
It's actually
DBCC SilverSpoons(Count)
Other options include
Max
Redundant
HaventLearnedYet
Imposter
Feed
Capacity (similar to logspace but used for brain cavity space)
Watch your data types on those. Some of them can overflow a bigint.
Overflow a bigint or a bigmouth?
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
January 21, 2016 at 3:56 am
just caught up on the 35 posts I was behind by...
Jason loved the list, especially the plot thickens ref...
DBCC COUNT_SPOONS - just thankful I am working from home today and had finished my coffee.
Gail's quantum state of the Crystal Ball, nice...
So T-shirts for this years Summit?
Rodders...
January 21, 2016 at 4:47 am
GilaMonster (1/20/2016)
djj (1/20/2016)
I missed if anyone ever found the crystal ball?It's in a quantum state. At best, sufficient need can collapse its waveform temporarily and cause a sudden burst of clarity, but it will always go back to unknown location, unknown momentum after a short time.
Thanks. Everything is now crystal clear.
January 21, 2016 at 5:09 am
Please, please, please, I already feel like I've been picking on this person, so no piling on. But they're looking for help and I don't think I'm providing it in the way they need it. Anyone else feel like they can contribute positively?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2016 at 5:20 am
Grant Fritchey (1/21/2016)
Please, please, please, I already feel like I've been picking on this person, so no piling on. But they're looking for help and I don't think I'm providing it in the way they need it. Anyone else feel like they can contribute positively?
I did my best.
January 21, 2016 at 5:36 am
Me, too
January 21, 2016 at 5:47 am
I find it slightly irritating that this fellow asks a question (not clearly) gets some good feedback from SQL MVPs and is combative. Plus, he uses far too many "!".
Now, if I'm getting some suggestions or recommendations from someone such as Grant, Gail, or Hugo I would be a little more on the appreciative side rather than combative. Hence, my suggestion to take his conversation to an Oracle forum (some are known for their snarky-ness).
Now I wonder, does this fellow have a Dev or QA environment where he can run some tests? Or does he plan on implementing whatever solution he chooses straight into Prod?
Viewing 15 posts - 52,306 through 52,320 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply