May 28, 2015 at 12:09 pm
Ed Wagner (5/27/2015)
GilaMonster (5/27/2015)
SQLRNNR (5/27/2015)
GilaMonster (5/27/2015)
Looks like I hit a few nerves with Sunday's editorial....Two words...
Ugh
Troll
I'd reply and point out the flaw in his logic (he's got scientific method and scientific consensus the wrong way around in cause and effect), but since he's already told me that he doesn't expect me to agree with him or to be right, I'll maybe save the effort.
Steve, maybe that thread needs a reminder on how to behave?
No matter how far south the discussion goes, Gail, I liked your editorial.
In Gail's case, that's pretty far south, geographically, of course. 😀
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]
May 28, 2015 at 12:09 pm
Brandie Tarvin (5/28/2015)
Well, unless someone used DBCC Timewarp() on it, the last I checked there was only one. But then again, someone did say DBCC Timewarp() was outdated and being downgraded. I don't remember what it was supposed to be replaced with, but maybe that new function / proc / whatever managed to duplicate another crystal ball for us.And then someone ran off with it without mentioning that there was a new one...
The crystal ball has a shared memory connection directly to the core of the DBCC Timewarp, this fools the optimizer into doing a reverse and forward time parallel scan within the notorious time sort operator, hence it can appear in many places at the same time.
😎
May 28, 2015 at 12:11 pm
ChrisM@Work (5/28/2015)
Ed has the crystal ball today, plus nerves of steel and the patience of a person with a tent guarded by a hippo..
Thanks, Chris. I try, but I don't always succeed. 😉
May 28, 2015 at 12:13 pm
Brandie Tarvin (5/28/2015)
ChrisM@Work (5/28/2015)
Ed has the crystal ball today, plus nerves of steel and the patience of a person with a tent guarded by a hippo..I really wish someone would pass me the crystal ball. I could use it over at my workplace this week.
I just shipped it overnight to you. You should have it by morning, so good luck. I couldn't get it to read the minds of the people I work with, though. It seems focused on technical stuff. I didn't try to rewire it or anything. I never got a manual with it and BOL is conspicuously missing an entry for it.
May 28, 2015 at 12:14 pm
Eirikur Eiriksson (5/28/2015)
Brandie Tarvin (5/28/2015)
Well, unless someone used DBCC Timewarp() on it, the last I checked there was only one. But then again, someone did say DBCC Timewarp() was outdated and being downgraded. I don't remember what it was supposed to be replaced with, but maybe that new function / proc / whatever managed to duplicate another crystal ball for us.And then someone ran off with it without mentioning that there was a new one...
The crystal ball has a shared memory connection directly to the core of the DBCC Timewarp, this fools the optimizer into doing a reverse and forward time parallel scan within the notorious time sort operator, hence it can appear in many places at the same time.
😎
Well, that explains why I was seeing some of the things I saw in my execution plan this morning. The proximity to the crystal ball was linked to DBCC Timewarp. It's becoming clearer now.
May 28, 2015 at 12:26 pm
Ed Wagner (5/28/2015)
Eirikur Eiriksson (5/28/2015)
Brandie Tarvin (5/28/2015)
Well, unless someone used DBCC Timewarp() on it, the last I checked there was only one. But then again, someone did say DBCC Timewarp() was outdated and being downgraded. I don't remember what it was supposed to be replaced with, but maybe that new function / proc / whatever managed to duplicate another crystal ball for us.And then someone ran off with it without mentioning that there was a new one...
The crystal ball has a shared memory connection directly to the core of the DBCC Timewarp, this fools the optimizer into doing a reverse and forward time parallel scan within the notorious time sort operator, hence it can appear in many places at the same time.
😎
Well, that explains why I was seeing some of the things I saw in my execution plan this morning. The proximity to the crystal ball was linked to DBCC Timewarp. It's becoming clearer now.
Happy to help Ed:-P
😎
May 28, 2015 at 10:48 pm
On the CELKO ban, interestingly I just got a notification email the he posted to Jeff's article: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations
But when I followed the link I got the red hyphen telling me an error occurred.
Apparently he's unaware he's been banned.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
May 29, 2015 at 2:34 am
dwain.c (5/28/2015)
On the CELKO ban, interestingly I just got a notification email the he posted to Jeff's article: Hierarchies on Steroids #2: A Replacement for Nested Sets CalculationsBut when I followed the link I got the red hyphen telling me an error occurred.
Apparently he's unaware he's been banned.
Same thing happened to me some days ago on a different thread.
Maybe SSC is applying a hellban method.
-- Gianluca Sartori
May 29, 2015 at 2:39 am
spaghettidba (5/29/2015)
dwain.c (5/28/2015)
On the CELKO ban, interestingly I just got a notification email the he posted to Jeff's article: Hierarchies on Steroids #2: A Replacement for Nested Sets CalculationsBut when I followed the link I got the red hyphen telling me an error occurred.
Apparently he's unaware he's been banned.
Same thing happened to me some days ago on a different thread.
Maybe SSC is applying a hellban method.
Never heard of that before. Pretty slick!
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
May 29, 2015 at 2:53 am
Steve Jones - SSC Editor (5/28/2015)
Is there just one? If there's a separate one for VS Online, pass it over.
Why? It'll only show clouds.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2015 at 4:18 am
GilaMonster (5/29/2015)
Steve Jones - SSC Editor (5/28/2015)
Is there just one? If there's a separate one for VS Online, pass it over.Why? It'll only show clouds.
Ahhh.. My funny for the day. @=)
May 29, 2015 at 4:55 am
dwain.c (5/29/2015)
spaghettidba (5/29/2015)
dwain.c (5/28/2015)
On the CELKO ban, interestingly I just got a notification email the he posted to Jeff's article: Hierarchies on Steroids #2: A Replacement for Nested Sets CalculationsBut when I followed the link I got the red hyphen telling me an error occurred.
Apparently he's unaware he's been banned.
Same thing happened to me some days ago on a different thread.
Maybe SSC is applying a hellban method.
Never heard of that before. Pretty slick!
I'd never heard of it either. Interesting approach.
May 29, 2015 at 4:57 am
Brandie Tarvin (5/29/2015)
GilaMonster (5/29/2015)
Steve Jones - SSC Editor (5/28/2015)
Is there just one? If there's a separate one for VS Online, pass it over.Why? It'll only show clouds.
Ahhh.. My funny for the day. @=)
That's cleaver. So, Brandie, be careful with the crystal ball and watch for danger because of the link to DBCC Timewarp. 😀
May 29, 2015 at 5:25 am
Ed Wagner (5/29/2015)
Brandie Tarvin (5/29/2015)
GilaMonster (5/29/2015)
Steve Jones - SSC Editor (5/28/2015)
Is there just one? If there's a separate one for VS Online, pass it over.Why? It'll only show clouds.
Ahhh.. My funny for the day. @=)
That's cleaver. So, Brandie, be careful with the crystal ball and watch for danger because of the link to DBCC Timewarp. 😀
Danger? More like trouble. Instead of the crystal ball, I ended up with a note on my desk from a future / parallel universe self. Apparently the crystal ball ended up with her to save the internet from self-destruction. Only because the internet apocalypse never happened, I never got the crystal ball or will have the crystal ball and none of us will remember what happened.
But at least parameter 186 of DBCC TIMEWARP() got fixed, because that's what she used to save the ... Wait a sec. If it never happened, did the parameter really get fixed?
My head hurts.
May 29, 2015 at 5:58 am
Ed Wagner (5/26/2015)
Brandie Tarvin (5/26/2015)
Luis Cazares (5/24/2015)
Would someone be interested on helping me to proofread an article that I'm planning to submit to SQLServerCentral? It's about while loops not being evil. 😀Wow. Talk about crossing lines... (j/k)
I do actually like WHILE loops on occasion.
I use WHILE loops myself when they're appropriate. My procedure to process backups loops through them and catches errors along the way. Like anything else, they have their place. The place is just smaller than many people seem to think it is.
Apart from backup and maintenance routines, I also use them for breaking work down into smaller batches to avoid escalation to table locks for things like archiving
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Viewing 15 posts - 48,661 through 48,675 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply